Forum Discussion
Next Top 5 Ranked
Hi PowerBIFan5 ,
As per your earlier post, you need to use the slicer as the basis for your selection, and if you don't want to enter it manually you can use hardcoding to specify the range of rankings you need to display.Top5 = IF( Table_1[Rank] > 6 && Table_1[Rank] <= 11, 1, 0 )Similar to the 6, and 11 here.
Best regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi PowerBIFan5 ,
As per your earlier post, you need to use the slicer as the basis for your selection, and if you don't want to enter it manually you can use hardcoding to specify the range of rankings you need to display.
Top5 =
IF(
Table_1[Rank] > 6 && Table_1[Rank] <= 11,
1,
0
)Similar to the 6, and 11 here.
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Albert, Thank you for taking the time to explain - makes sense. I needed something that would be dynamic since the selected item rank will change depending on what's selected. I ended up solving the issue using a duplicate fact table.