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.
hi there,
I'm hoping someone here can help as I've been trying to figure it out for a few days and no luck.
I am trying to show a matrix visual and that shows each week as a column and it shows the items that fall on each week.
I am using the Rankx function to show the order on which the items appear.
Here is my formula:
Ranking =
RANKX(
FILTER(ALLSELECTED(OSCR),
OSCR[WeeklyDate]= EARLIER(OSCRTransformed[WeeklyDate])),
CALCULATE(SUM(OSCR[Index]),FILTER(OSCR,OSCR[Index] <= EARLIER(OSCR[Index] ))),,ASC)
My problem is when it genearates the matrix visual, some of the 'blocks' are 'floating'. The ranking is skipping numbers.
I need it to rank based on the following :
By area, key and week
Is this possible?
I need it to number or order the rank based on what area it's in, the key and what week it falls in. Right now it just does the week. So for a particular week it will number it, say 1-15, except it includes different areas and keys.
How can I add the other two in the formula?
Thanks in advance!
Solved! Go to Solution.
I got it working.
I just added an "AND" statement (use "&&" if you have more than 2 conditions) and it works.
Just wanted to post here in case someone else encounters this issue.
Thank you!
I got it working.
I just added an "AND" statement (use "&&" if you have more than 2 conditions) and it works.
Just wanted to post here in case someone else encounters this issue.
Thank you!
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |