hi

[abc_777]

hello

i have a measure

actual quantity = Sum(sale_quantity) - Sum(Return_quantity)

I want the value of this measure as constant on a table matrix.  Mean it won't filter when I select any slicer.  The value would be the same

also, I want to use this same measure for another table matrix where I can change the value as per slicer selection

can I use this single measure for these two tables one for constant value and another for slicer selection or

Do I have to make two measures for two table matrices?

If so then please tell me how I can make the constant value of a measure

thanks

[ribisht17 · Accepted solution]

@abc_777 

1. Select the slicer.
2. Tab Format > Edit interaction.
3. Deactivate all visuals accept the one that should be filtered by the slicer.

Refer > Solved: Associate a slicer to a single visual - Microsoft Power BI Community

Thanks,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users