Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello, I have recently started to use PowerBI.
We have data for sales within the (Emi_Todas) table, and a related table of sellers (PAS), wich contains data for each seller.
The sellers table (PAS), whose primary key is MPROD has 2 different subgroups: Group 1: MPROD<45000 and Group2 MPROD>=45000.
I´m currently trying to show the position in the ranking for a specific seller (MPROD) according to total sales [Prima], making a difference whether both groups of sellers are considered or only the first Group is considered.
So, I created two different meassures:
Solved! Go to Solution.
@DavidGolden
Maybe a different approach then? If you want to return blank when the [MPROD] >= 45000 you can include this in the measure using IF. So IF([MPROD] >= 45000,BLANK(),[Ranking measure])
Proud to be a Super User!
That´s right.
Since the idea is to insert a slicer in order to chose among sellers, then I had to include MAX/MIN for IF function to work.
Hi,
Instead of filtering the PAS table you should focus on chaning the measure logic. Example,
Here I only want to rank products with Category "B" :
Proud to be a Super User!
Hi @ValtteriN , thanks for the advice. I applied your aproach the the syntax. However, the result is still the same as before.
When chosing a member from a different category, the returned value is not blank, but the last position in the ranking, wich is incorrect.
@DavidGolden
Maybe a different approach then? If you want to return blank when the [MPROD] >= 45000 you can include this in the measure using IF. So IF([MPROD] >= 45000,BLANK(),[Ranking measure])
Proud to be a Super User!