Multiple Filters into DAX Calculation

[hegde86]

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

[v-juanli-msft]

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]

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

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