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

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

Hi xiumi_hou ，

 

Measure “SF_Before_A1” should be corrected as below:

 

 

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

 

Or  

 

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

 

 

 

As you’re calculating a result based on measure 1,and measure 1 is based on table “Cases”, if you wanna use filter function, it should be within table “Cases”.

 

If it doesn’t work, pls show me your sample data.

 

Hope this would help.

 

Best Regards,

Kelly