Forum Discussion
rcyber
Resolver I
Resolver IDynamic 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...
Zubair_Muhammad
Community Champion
Community ChampionHi rcyber
Try adjusting the Rank formula as follows
Rank CC Area =
RANKX (
SUMMARIZE ( ALLSELECTED ( Data ), Data[Area], Data[Exp Category] ),
CALCULATE (
SUM ( Data[USD] ),
ALLEXCEPT ( Data, Data[Area], Data[Exp Category] )
)
)
- Zubair_Muhammad
And Cumulative Area as follows
Cumulative Area Total = VAR rr = [Rank CC Area] RETURN ( CALCULATE ( SUM ( Data[USD] ), FILTER ( SUMMARIZE ( ALLSELECTED ( data ), Data[Area], Data[Exp Category] ), [Rank CC Area] <= rr ) ) )- rcyber
Thanks a lot for quick help.
It works good and calculates rank correctly.
But it's not exactly what I want co create.
The SUMMARIZE function calculates subtotals with filtering by Data[Area] and Data[Exp Categories] fields.
But I want to calculate (and rank next) subtotals grouping by Data[Area] and filtering Data[Area] and Data[Exp Categories] both.
I want to create the report like this:
I hope you understand what I mean.
Thanks in advance,
Alexander.
- Zubair_Muhammad
