Forum Discussion

xiumi_hou's avatar
xiumi_hou
Icon for Post Partisan rankPost Partisan
6 years ago
Solved

urgent: Quick question for dax

Dear all,   I have two measures.  I want to count the number of [measure 1] that the measure 2's result is 0   When I use measure 1 as a card view and put measure 2 to a filter(set=0) which works...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi xiumi_hou ,

     

    Yes,my measure is based on yours,have you tried it?

    Your measure "SF_Before_A1" should be corrected to either of the following ones:

     

    SF_Before_A1 = calculate([SF_case_inactive], 'Calls'[Count_Held_Sessions_A1]=0)

     

    Or

     

    SF_Before_A1 = If ('Calls'[Count_Held_Sessions_A1]=0,[SF_case_inactive],blank())

     

    I just advise you not to use "filter" funtion in this situation.

    And measure 1 and measure 2 remain the same.

    Pls try it and advise me if there's any error returned.

     

    Best Regards,

    Kelly

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

When you filter Measure1 using Measure2 you need to data grouping at some level to filter

Like

Sumx(filter(values(table[id],measure2 >0),measure1)

Sumx(filter(summarize(table[id],"M1",sum(measure2),"M2",sum(measure1)),[M2]>0),[M1])

 

 

  • xiumi_hou's avatar
    xiumi_hou
    Icon for Post Partisan rankPost Partisan
    6 years ago

    Can you help me revise mine? Thank you so much

    • v-kelly-msft's avatar
      v-kelly-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi xiumi_hou ,

       

      Yes,my measure is based on yours,have you tried it?

      Your measure "SF_Before_A1" should be corrected to either of the following ones:

       

      SF_Before_A1 = calculate([SF_case_inactive], 'Calls'[Count_Held_Sessions_A1]=0)

       

      Or

       

      SF_Before_A1 = If ('Calls'[Count_Held_Sessions_A1]=0,[SF_case_inactive],blank())

       

      I just advise you not to use "filter" funtion in this situation.

      And measure 1 and measure 2 remain the same.

      Pls try it and advise me if there's any error returned.

       

      Best Regards,

      Kelly