Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Kent Søndergaard]

Hallo,

 

I have a product table that is connected with 1. a product table and 2. a listing table. Listing says something about how products are taken in by a customer, so for example; Q2 Product X in Jula is 80% of the stores. Therefor it’s connected via a Period/Product/Customer item that I have made in the listing table, and the same in the Data table.

 

The product table is only connected via the product code

 

 

So far so good.

My problem is the Listing Group coming from the ListingData table. It’s a different code base on the assumed distribution of the product when I put that one in the rank is all over the place. It looks like there is a rank for each code, so eg. The code “8” has a 1, 2 or 3…. And then the “9” has that one as well…

 

I hope someone can help om ranking them in a normal way – also with the listing code in the table.

 

Br Kent

 

[Farhan Ahmed]

Hi 

Try something like this…

__Rnk = RANKX(ALLSELECTED(Data),

CALCULATE(sum(Data[Value]),

ALLEXCEPT(Data,Data[Period Item Banner],
Data[Prod Tag],Product[Product Desc],
ListingData[Listing Group])),,DESC,Dense)?

——————————
Farhan Ahmed
Senior Business Intelligence Consultant
karachi
3452523688
——————————
——————————————-

[Kent Søndergaard]

—

[Kent Søndergaard]

Hi ?,

I’ve entered the expression but the result is not as expected. The RANK is 1,1,1,1,1, and some time 2.

Do you know why and what to do?

Kent

——————————
Kent Søndergaard
Owner
One Click Insight AS
Slependen
9174350
——————————
——————————————-

[Farhan Ahmed]

Can you please share the formula and screenshot of external filters ? because AllExcept will not work if any other external filter is not included in it.

——————————
Farhan Ahmed
Senior Business Intelligence Consultant
karachi
3452523688
——————————
——————————————-