Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Incorrect values in pivot table from Tabular model

Hi I tried for several days to fix this but to no avail so appreciate all/any help! I have a model built in SSAS Tabular. When checking my metric in Excel pivot table, it gives the wrong value in ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI Anonymous,

 

I'd like to suggest you to take a look at following blog about deal with calculation on hierarchy level subtotal:

Clever Hierarchy Handling in DAX

 

Regards,
Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    thanks for that link, I will check it out now