Forum Discussion
Helper IRank on two tables visuals
AnnaMagnusson , You can switch Rank measure using slicer or context.
You can use isinscope or isfiltered to switch measure.
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.Hi!
Sorry for not answering.
I think the problem is fixed. Your solution was in the right direction with using switch. Since I only had measures and only one column (parameters) I couldn't use isinscope or isfiltered (what I could understand).
What I ended up using was:
RankCompare = SWITCH( TRUE(),[Rank F] = 1, "1",[Rank F] = 2, "2",[Rank F] = 3, "3",[Rank F] = 4, "4",[Rank F] = 5, "5")where [Rank F] = if( isblank(measure), blank(), rankx ( all( table [column]) , measure, , , dense)) is from the ranking on the first table visual and then I just sorted the second table visual on RankCompare.
So thanks for the help!
Super UserAnnaMagnusson , You can switch Rank measure using slicer or context.
You can use isinscope or isfiltered to switch measure.
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.