Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi i have the below table visual and i am looking at calculating the cumulative percentage. I created the below measure however its not calculating this properly. Can anyone please advise?
Solved! Go to Solution.
Hi @Anonymous
here is a sample. Adjust it for your needs:
Running Percentage =
VAR _Total =
CALCULATE ( [Waste Value], ALL ( 'Table' ) )
VAR _Percentage =
DIVIDE ( [Waste Value], [Total] )
VAR _WasteValue =
SUM ( 'Table'[Waste Value_] )
RETURN
IF (
HASONEVALUE ( 'Table'[Loss Reason] ),
CALCULATE (
[Percentage],
FILTER (
ALL ( 'Table' ),
'Table'[Waste Value_] >= MAX ( 'Table'[Waste Value_] )
)
)
)
With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)
Hi @Anonymous ,
Created some data:
Here are the steps you can follow:
1. Enter power query through Transform data, Add Column – Index Column –From 1.
2. Create measure.
Expected Output =
var _1=SUMX(FILTER(ALLSELECTED('Table'),'Table'[Index]<=MAX('Table'[Index])),'Table'[Waste Value])
var _2= SUMX(ALL('Table'),'Table'[Waste Value])
return
DIVIDE(_1,_2)
3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Created some data:
Here are the steps you can follow:
1. Enter power query through Transform data, Add Column – Index Column –From 1.
2. Create measure.
Expected Output =
var _1=SUMX(FILTER(ALLSELECTED('Table'),'Table'[Index]<=MAX('Table'[Index])),'Table'[Waste Value])
var _2= SUMX(ALL('Table'),'Table'[Waste Value])
return
DIVIDE(_1,_2)
3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
You can use the following formula
Regards,
Sayali
If this post helps, then please consider Accept it as the solution to help others find it more quickly
**bleep** PCT =
var total =CALCULATE('Waste Data Measures'[Waste Value Total],REMOVEFILTERS('Waste Data Measures'[Loss Reason]))
var cur = 'Waste Data Measures'[Waste Value Total]
RETURN
DIVIDE(cur,total,0)
Proud to be a Super User!
Hi @Anonymous
here is a sample. Adjust it for your needs:
Running Percentage =
VAR _Total =
CALCULATE ( [Waste Value], ALL ( 'Table' ) )
VAR _Percentage =
DIVIDE ( [Waste Value], [Total] )
VAR _WasteValue =
SUM ( 'Table'[Waste Value_] )
RETURN
IF (
HASONEVALUE ( 'Table'[Loss Reason] ),
CALCULATE (
[Percentage],
FILTER (
ALL ( 'Table' ),
'Table'[Waste Value_] >= MAX ( 'Table'[Waste Value_] )
)
)
)
With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |