Forum Discussion

TL's avatar
TL
Regular Visitor
7 years ago
Solved

Category/Subcategory Calculation

I am very new to Dax and am guessing the solution is right under my nose, but I've exhausted my limited knowledge and need some guidance.   The data indicates number of people per category and with...
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi TL

    Try this measure

    Measure = IF(HASONEVALUE(Sheet7[category]),[Manpower/SubCategory(Category)],
                 SUMX(VALUES(Sheet7[category]),[Manpower/SubCategory(Category)]))

     

    Best Regards

    Maggie

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi TL

Try this measure

Measure = IF(HASONEVALUE(Sheet7[category]),[Manpower/SubCategory(Category)],
             SUMX(VALUES(Sheet7[category]),[Manpower/SubCategory(Category)]))

 

Best Regards

Maggie

TL's avatar
TL
Regular Visitor
7 years ago

v-juanli-msftThanks Maggie! That did the trick.  I'm now reviewing and reviewing again so I understand the logic used.