Forum Discussion
Post ProdigyPareto not working
Hi, o59393
I am sorry to reply to you so late.Create a new Index named Secondary Index in PowerQuery as a unique identifier and as a secondary sort.
Close and Apply. Then create a new measure and try the following DAX expression:
Index Test = ROWNUMBER ( ALLSELECTED ( Template[Facet], Template[Tier 1: Process Facet], Template[Tier 2: Activity Facet] ), ORDERBY ( [Non Duplicate Hours Process/Activity 3],DESC, MAX('Template'[Secondary Index]),ASC ) )Here is my Preview:
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Post ProdigyHi Anonymous
Please see attached a pbix sample: https://drive.google.com/file/d/1rID6tbIhYqanx6gcQnDaLESnn3eZr3vQ/view?usp=sharing
You will see repeated index (8 and 10 for example) where they have the same % value 3.51% and 2.51% respectively.
The desired outcome would be to have the Running % column making the cumulative sum in each row.:
Thanks.
Hi, o59393
I am sorry to reply to you so late.
Create a new Index named Secondary Index in PowerQuery as a unique identifier and as a secondary sort.
Close and Apply. Then create a new measure and try the following DAX expression:
Index Test =
ROWNUMBER (
ALLSELECTED (
Template[Facet],
Template[Tier 1: Process Facet],
Template[Tier 2: Activity Facet]
),
ORDERBY ( [Non Duplicate Hours Process/Activity 3],DESC, MAX('Template'[Secondary Index]),ASC )
)
Here is my Preview:
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.