Forum Discussion

arashaga's avatar
arashaga
Helper I
7 years ago
Solved

Issue with the Subtotal using DAX

I have the folowing table ( partial).                I use the following DAX measure to get the sum of [# Change 2014-2024] per Occupation. Why I am doing this is becuase I I do not do th...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    OK, so probably something like:

     

    Total Demand Intermediate = sum(UTSATEST[# Change 2014-2024])/DISTINCTCOUNT(UTSATEST[Major (CIP Title)])

Total Demand = 
IF(
  HASONEVALUE(UTSATEST[Occupation]),
    [Total Demand Intermediate],
    SUMX(SUMMARIZE(UTSATEST,[Occupation],"__Total",[Total Demand Intermediate]),[__Total])
arashaga's avatar
arashaga
Helper I
7 years ago

Thanks for the reply. I edited the original question and added the DAX measure at the end.