Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone,
I am pretty new to PowerBI and have a question.
I want to do something rather simple but I am lacking the syntax to do it. I constantly produce errors or wrong results, which is why I am trying my luck on here.
A simplified version of what I want to do is this:
I have column A and B in my data set and I want to calculate column C and D in the data model:
I know that I have to use "calculate" and "countrows" and "filter" and "rank" but I just can't figure out how to solve this. Please note that I can't use absolute values for neither product nor category, because I have 539 distinct products in 259 distinct categories.
Any input is very much appreciated.
Solved! Go to Solution.
Try out these two columns:
Count = VAR __table = FILTER(ALL('Table7'),[A] = EARLIER([A]) && [B] = EARLIER([B])) RETURN COUNTX(__table,[B]) Rank = RANKX(FILTER(ALL('Table7'),[B] = EARLIER([B])),[Count],,DESC,Dense)
See Table7 of attached.
Try out these two columns:
Count = VAR __table = FILTER(ALL('Table7'),[A] = EARLIER([A]) && [B] = EARLIER([B])) RETURN COUNTX(__table,[B]) Rank = RANKX(FILTER(ALL('Table7'),[B] = EARLIER([B])),[Count],,DESC,Dense)
See Table7 of attached.
Works as intended. Thank you very much.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |