Forum Discussion

MetroRogi's avatar
MetroRogi
Regular Visitor
2 years ago
Solved

DAX: remove visual filter set by a measure for calculation

Hello Experts,   I have a visual of top-3 cutomers and their revenue. The rank is done as a measure and added to a visual filter.   I'd like to include in this visual another measure, which shoul...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi johnbasha33 ,thanks for the quick reply, I'll add further.

    Hi MetroRogi ,

    Regarding your question, the argument to the function does need to be a column rather than a measure.Perhaps you could add your rankings as filters to the measure instead of adding the rankings to the filter window.

    The Table data is shown below:

     

     

    Total = SUM('Table'[Column2])
    Rank = RANKX(ALL('Table'[Column1]),[Total],,DESC,Skip)
    Measure = IF( [Rank] <4,[Total])

     

     

    Final output:

     

    Finally you can add additional measures.

     

     

     

     

     

     

johnbasha33's avatar
johnbasha33
Icon for Super User rankSuper User
2 years ago

MetroRogi  create a measure like below, this will do the job.
Total Revenue (Ignore Rank) =
CALCULATE(
[Total Revenue],
ALL('Customer'[CustomerName])
)


Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!