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
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 )
        )
    )