Forum Discussion
Solved
Help with a Top value
Hi Guys, I am trying to create a "Hall of Fame" tab in my report. pretty much, i want the user to select one of many measures that describe my data, and then be able to select top 10% of va...
Hi aar0n,
Create a new table Options like below:
Then create a measure in the table using DAX:
Result = SWITCH ( TRUE (), SELECTEDVALUE ( Options[Options] ) = "Top 10% Names By Average", [Top 10% Names By Average], SELECTEDVALUE ( Options[Options] ) = "Top 10% Names By Total", [Top 10% Names By Total], SELECTEDVALUE ( Options[Options] ) = "Top 10% Names By Max", [Top 10% Names By Max] )Regards,
Jimmy Tao
Hi aar0n,
Create a new table Options like below:
Then create a measure in the table using DAX:
Result =
SWITCH (
TRUE (),
SELECTEDVALUE ( Options[Options] ) = "Top 10% Names By Average", [Top 10% Names By Average],
SELECTEDVALUE ( Options[Options] ) = "Top 10% Names By Total", [Top 10% Names By Total],
SELECTEDVALUE ( Options[Options] ) = "Top 10% Names By Max", [Top 10% Names By Max]
)
Regards,
Jimmy Tao
hi v-yuta-msft
this reply is so close, but not exactly what i am looking for..
in the end, i am hoping to have multiple visuals, and not just a data card.
in my example screenshot below, if i click on "Top 10% Names By Total", i need the graph visual to only show me the name "A"
if i click on "top 10% Names by Max", i need the graph visual to show b,c
in my small subset of test data, it may not be too difficult to filter from the data card value.. but my actual dataset has ~8 million rows, and ~5k names...
Example