Forum Discussion

SpiroswayGR's avatar
SpiroswayGR
Resolver III
4 years ago
Solved

Percentage on Subcategory

Hello everyone,   I want to create a subcategory percentage but something goes wrong. I found some related solutions but it looks like they are not working because I have measured instead of...
Need Help
  • SpiroswayGR's avatar
    SpiroswayGR
    4 years ago

    v-kkf-msft thank you! thumb up for your solution!

     

    My solution at the end

    Ar_SubCat_% =
    VAR NumA = IF( ISBLANK( table1[measure2]), BLANK(), CALCULATE(table1[measure2], ALLSELECTED(Calendar_System[DateBand]) ) )
    VAR NumB = table1[measure2]
       
    VAR div22 = DIVIDE(NumB, NumA, 0 )
    Return div22
SpiroswayGR's avatar
SpiroswayGR
Resolver III
4 years ago

any correction for this dax? maybe change sumx to sum ?