Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
77 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |