Forum Discussion

dorku's avatar
dorku
Frequent Visitor
1 year ago
Solved

Limit Data WITHOUT TOPN

  Hello everyone, I have a question about a table (drill-through) I use in my dashboard. The table is based on a fact table (with one item per row) and can dynamically display anywhere between 5 r...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi, dorku 

     

    You can try the following methods.

    Sample data:

    Measure = Var _rank=RANKX(All('Table'),CALCULATE(MAX('Table'[Date])),,DESC,Dense)
RETURN
IF(_rank<=10,1,0)

    Place this measure on filters on this visual and set it equal to 1.

    At this point, the top ten data by date are displayed by default. If you choose to clear the filter, all data will be displayed.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi, dorku 

 

You can try the following methods.

Sample data:

Measure = Var _rank=RANKX(All('Table'),CALCULATE(MAX('Table'[Date])),,DESC,Dense)
RETURN
IF(_rank<=10,1,0)

Place this measure on filters on this visual and set it equal to 1.

At this point, the top ten data by date are displayed by default. If you choose to clear the filter, all data will be displayed.

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.