Forum Discussion

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

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

      You can use ISINSCOPE to check whether a column is the level in a hierarchy of levels.

      Measure02 = 
VAR numerator =
    CALCULATE (
        DISTINCTCOUNT ( 'S rate'[success] ),
        'S rate'[inclusion flag] = "Y"
    )
VAR denominator =
    DISTINCTCOUNT ( 'S rate'[success] )
VAR _pct =
    DIVIDE ( numerator, denominator )
RETURN
    IF ( ISINSCOPE ( region[region] ), _pct + 0, _pct )