Forum Discussion
ViralPatel212
1 year agoResolver I
Measure to Identify Values in table when filtered
Hello Team, I have a visual where im using the "counter_party_ column from a table called "Counterparty". I am trying to create a dax or a calcualted column to identify the following issue: *Ple...
- 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.
ViralPatel212
1 year agoResolver I
johnt75 You sir are a Genius!! i was able to add this as a variable and the called it in the measure!
TREATAS( VALUES( Counter party slicer[counter_party] ), Counterparty_tbl[counter_party] )