Forum Discussion

aar0n's avatar
aar0n
Advocate II
8 years ago
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...
Need Help
Show and Tell
Tutorial Requests
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    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

aar0n's avatar
aar0n
Advocate II
8 years ago

hi v-yuta-msft, 

thank you for your quick response. this reply is very helpful, but there are some changes i was hoping for, 

 

for example, 

instead of just displaying the measure in a data card, would it be possible to use the measure (or a different method) in some type of filter?

what i was hoping for was the ability to click "top 10% names by max" and then my other visuals in my report would filter to those names.

 

 

The reason i need this, is that Power bi only graphs a subset of my data (and i can't truly see the top percentile of data)

v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

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

  • aar0n's avatar
    aar0n
    Advocate II
    8 years ago

    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