Forum Discussion

ViralPatel212's avatar
ViralPatel212
Resolver I
1 year ago
Solved

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...
  • johnt75's avatar
    johnt75
    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.