Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a data set like below.
I want to create measures Sum,Qty Contribution, Commulative Contribution. Here Sum is total of Item Qty for each slicer. Qty Contribution is weightage of that to total sum. i.e. Item Qty/Sum. Commulative Contribution is Cummulative Sum of Contribution.
Here challenge is bringing Slicer and Key into filter context. I can bring Slicer into filter context using SelectedValue function. But how to bring Key into filter context. Please help me to generate this calculation.
Thanks in Advance,
Rajesh S Hegde
Hi @hegde86
Create measures
sum = CALCULATE(SUM('Table'[item qty]),FILTER(ALLSELECTED('Table'),'Table'[slicer value]=MAX('Table'[slicer value]))) contribution = SUM('Table'[item qty])/[sum] clc contribution = SUMX ( FILTER ( ALLSELECTED ( 'Table' ), 'Table'[slicer value] = MAX ( 'Table'[slicer value] ) && 'Table'[key] <= MAX ( 'Table'[key] ) ), [item qty] ) / [sum]
You can try
overAll =CALCULATE(sum(Sales[Sales]),ALLSELECTED()) Cont Sales = var var1 = CALCULATE(SUM(Sales[Sales]),ALLSELECTED()) return DIVIDE(SUM(Sales[Sales]),var1)*100
for running total refer
https://community.powerbi.com/t5/Desktop/Running-total/td-p/502657
https://community.powerbi.com/t5/Desktop/Cumulative-Total/td-p/43115
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |