Forum Discussion
Measure to Identify Values in table when filtered
- 1 year ago
If you just need it for one measure, you could use something like
My Measure = CALCULATE( SUM( 'Table'[Value] ), TREATAS( VALUES( Counter party slicer[counter_party] ), Counterparty_tbl[counter_party] ) )replacing the SUM with whatever calculation you needed.
If you want to apply it to multiple measures you could use a calculation group and create a calculation item like
Calc Item = CALCULATE( SELECTEDMEASURE(), TREATAS( VALUES( Counter party slicer[counter_party] ), Counterparty_tbl[counter_party] ) )and then apply that calc item as a filter on the visuals you want to impact.
Not within visuals, but you could make it have an effect in measures by using
TREATAS( VALUES( Counter party slicer[counter_party] ), Counterparty_tbl[counter_party] )johnt75 How can i have that incorporated into my measure and make it work?
- johnt751 year agoSuper User
If you just need it for one measure, you could use something like
My Measure = CALCULATE( SUM( 'Table'[Value] ), TREATAS( VALUES( Counter party slicer[counter_party] ), Counterparty_tbl[counter_party] ) )replacing the SUM with whatever calculation you needed.
If you want to apply it to multiple measures you could use a calculation group and create a calculation item like
Calc Item = CALCULATE( SELECTEDMEASURE(), TREATAS( VALUES( Counter party slicer[counter_party] ), Counterparty_tbl[counter_party] ) )and then apply that calc item as a filter on the visuals you want to impact.