Forum Discussion

rcyber's avatar
rcyber
Resolver I
8 years ago

Dynamic rank issue

Hi all! I'm trying to create the Pareto chart based on multiple slicers. I have two columns for slicing. They are named "Area" and "Exp Category". And I have the "USD" column. It contains amounts I...
Need Help
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Hi rcyber

 

I will look into it and get back to you

rcyber's avatar
rcyber
Resolver I
8 years ago
Hi
 

Do you have any ideas about my question?

Best regards,
Alexander.

 

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    Hi rcyber

     

    My apologies for late reply...

     

    Please try this revised MEASURE.

     

    File attached here as well

     

    Rank CC Area =
RANKX (
    ALLSELECTED ( Data[Area] ),
    CALCULATE ( SUM ( Data[USD] ) ),
    ,
    DESC,
    DENSE
)

     

    Cumulative Area Total =
VAR rr = [Rank CC Area]
RETURN
    (
        CALCULATE (
            SUM ( Data[USD] ),
            FILTER ( ALLSELECTED ( Data[Area] ), [Rank CC Area] <= rr )
        )
    )