Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
I have the below table, where i calculated the cumulative %
1.i want to show The top 80% issues should be based on a rolling 3 month total. in my example is 1 month
2. i want to allow user to filter by top x%, but default setting should be to show top 80%. Filter should allow 10-100% and in 10% increments
Any idea would be helpfull!
Hi @a-simarg ,
For your first issue, you need to use SUM() function to get three months of data.
For your second question, you need to use measure to calculate the percentage. Then use What if Parameter to get a slicer, add an if judgment in the measure. In the filter ,set the measure is not null.
aggdiv = VAR a = CALCULATE ( SUMX ( 'Table', [sumdiv] ), FILTER ( ALL ( 'Table' ), 'Table'[Column] <= MAX ( 'Table'[Column] ) ) ) RETURN IF ( [per Value] >= a, a )
Here is the result.
Best Regards,
Eads
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for reply.
I followed all the steps and I have the below error. Can you please help on this also?
Hi @a-simarg ,
Please replace "[RANK INR]<=MAX( [RANK INR] )" with "[RANK INR]<=MAXX( 'Table',[RANK INR] )".
Best Regards,
Eads
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
How did you calculated the [sumdiv]?
I think this is from where my issue comes
Thanks
Simona
Thanks for reply. No error after changing that paragraph.
Now, this measure do not return any data. only blank.
Just to specify that, i want to be able to filter the cumulative percent from my screenshot. The cumulative Percent it is a measure.
Any idea?
Thanks
Simona
Creating a What if parameter also creates the below measure.
Should i change the value from "Selectedvalue" ?
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |