calculate contribution to total ignoring certain field selection

[mogugu_84]

i need to create a measure of contribution to total sales per each area (brick), it needs to ignore all product selection (in this case product =molecule),

this is what i wrote so far, i have tried "ALL" and "Removefilters" forumla, neither works, when i click on the molecule silcer to the right, the numbers change. i just need the numbers to NOT respond the the molecule selection, anyone can help with that? 

[Anonymous]

Hi @mogugu_84 ,

If you want to ignore all product selection, you can try canceling the interaction from your slicer to the visual contains Contribution 2.

Reference:

Change how visuals interact in a report - Power BI | Microsoft Learn

Best Regards,
Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[anmolmalviya05]

Hi @mogugu_84, Hope you are doing good!

Please try the below measure:

Contribution to Total Sales =
VAR TotalSales =
CALCULATE(
[MAT],
REMOVEFILTERS('Def market'[Molecule]) -- Ensures Molecule filters are ignored
)
RETURN
[MAT] / TotalSales

[mogugu_84]

thank you, i tried this "removefilters" formula, hope it got it right in the above, but the calculation is not correct, when no molecule is seleted, now it shows all 100% for each row item (area/brick)

Also when i do select one of the molecules, the numbers still changes as well....

[Anonymous]

Hi @mogugu_84 ,

Check if Solved: Filter and Allexcept - Microsoft Fabric Community works for you.

Cheers

ChenuSing

[mogugu_84]

Sorry CheenuSing, can you be a bit more specific? (Sorry I should have copied the formula as text so that is easier...but now I'm on my mobile)