Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX Measure

Looking for a DAX measure: Looking for measure that would filter according to a column: Example: Measure 1 = Calculate(Sum('Trade'[Value]), filter='Reporter Country') Measure 2 = Calculate(Sum(...
Need Help
  • VahidDM's avatar
    VahidDM
    4 years ago

    Hi Anonymous 

     

    You need to use the selectedvalue DAX formula:

     

     

    Mreasure 1 =
VAR _A =
    SELECTEDVALUE ( 'Trade'['Reporter Country'] )
RETURN
    CALCULATE (
        SUM ( 'Trade'[Value] ),
        FILTER ( ALL ( 'Trade' ), 'Trade'['Reporter Country'] = _A )
    )

     

     

     

    Mreasure 2 =
VAR _A =
    SELECTEDVALUE ( 'Trade'['Partner Country'] )
RETURN
    CALCULATE (
        SUM ( 'Trade'[Value] ),
        FILTER ( ALL ( 'Trade' ), 'Trade'['Partner Country'] = _A )
    )

     

     

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!
    LinkedIn:     www.linkedin.com/in/vahid-dm/

     

     

     

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    measure =
    CALCULATE (
    SUM ( 'Trade'[Value] ),
    FILTER (
    ALLSELECTED ( 'Trade' ),
    'Trade'[Reporter Country] = SELECTEDVALUE ( 'Reporter'[Reporter Country] )
    && 'Trade'[year] = SELECTEDVALUE ( 'year'[year] )
    && 'Trade'[product] = SELECTEDVALUE ( 'product'[product] )
    )
    )

    Or

    measure =
    CALCULATE (
    SUM ( 'Trade'[Value] ),
    FILTER (
    ALL ( 'Trade' ),
    'Trade'[Reporter Country] = SELECTEDVALUE ( 'Trade'[Reporter Country] )
    && 'Trade'[year] = SELECTEDVALUE ( 'Trade'[year] )
    && 'Trade'[product] = SELECTEDVALUE ( 'Trade'[product] )
    )
    )

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Can we add multiple filter?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Nope it should filter country column, Year colum, Product column

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Anonymous ,

       

      measure =
      CALCULATE (
      SUM ( 'Trade'[Value] ),
      FILTER (
      ALLSELECTED ( 'Trade' ),
      'Trade'[Reporter Country] = SELECTEDVALUE ( 'Reporter'[Reporter Country] )
      && 'Trade'[year] = SELECTEDVALUE ( 'year'[year] )
      && 'Trade'[product] = SELECTEDVALUE ( 'product'[product] )
      )
      )

      Or

      measure =
      CALCULATE (
      SUM ( 'Trade'[Value] ),
      FILTER (
      ALL ( 'Trade' ),
      'Trade'[Reporter Country] = SELECTEDVALUE ( 'Trade'[Reporter Country] )
      && 'Trade'[year] = SELECTEDVALUE ( 'Trade'[year] )
      && 'Trade'[product] = SELECTEDVALUE ( 'Trade'[product] )
      )
      )

       

      Best Regards,

      Jay