Hi All,
Is there any solution to show corresponding rank of a measure. I need to put this as in filter which should work for all sheets.
below is the calculation which i am using.
WINDOW_MIN(ATTR([Country]))
I need country as a global filter to work.
Any help would be great.
Regards
4 Antworten
I'd suggest creating a parameter for the country. Then create the following calculated field:
Country Filter
// Filter to the country selected in the paramter.
// Make sure it's a table calc so it won't affect the rank.
LOOKUP(MAX(
IF [Country]=[Country Parameter] THEN
TRUE
ELSE
FALSE
END
), 0)
Then use that as a filter on both sheets, keeping TRUE values only.
Finally, on your dashboard, show the Country parameter.
See attached.
