Forum Discussion

danextian's avatar
danextian
Icon for Super User rankSuper User
1 year ago

Hi animebuff 

 

numerator=BLANK() && denominator=BLANK(),1,

This is telling DAX to return 1 when both the numerator and the denominator are both blank and this is true for January.

 

 numerator=BLANK(),0,

This is telling DAX to return 0 a when the numerator is blank  and this still is true for January. 0 value categories are not hidden so a column for January will still appear.

 

So why not just use

DIVIDE ( numerator, denominator )

Note: I am using DIVIDE as a best practice.

 

  • animebuff's avatar
    animebuff
    Icon for Helper I rankHelper I
    1 year ago

    but, in my scenario divide dax will not change the results

     

    and jan month is not present in fact table so I need to avoid it 

    • danextian's avatar
      danextian
      Icon for Super User rankSuper User
      1 year ago

      what do you mean by ' in my scenario divide dax will not change the results"?

      I tested this simple DIVIDE formula and it excludes january

       

      • animebuff's avatar
        animebuff
        Icon for Helper I rankHelper I
        1 year ago

        danextian thanks for the reply,

         

         

        but your logic will give correct results on month wise but if you drill down to region it will fail
        bottom 2 ( 3 and 4 ) are based on the logic you gave

         

        my expectation is I need to get 3rd (image) on month wise and 2rd (image) on region wise drill down
        note: drill down done on nov month