Forum Discussion
hi
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
- Select the slicer.
- Tab Format > Edit interaction.
- 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
1 Reply
- ribisht17Super User
- Select the slicer.
- Tab Format > Edit interaction.
- 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