Forum Discussion

abc_777's avatar
abc_777
Solution Specialist
4 years ago
Solved

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

 

 

1 Reply