Forum Discussion
DAX Calculation doesn't work when collapsing groups
Hi, Koushikrish
You can check the document: Use composite models in Power BI Desktop - Power BI | Microsoft Docs
It mentions:
From your screenshot I can see that they are composite models. So I think this is the cause of the problem.
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,Community Support Team _ Janey
Thank you for the response!
I still do not understand how the 1st and 2nd measures work in the same context considering they are DAX calculations as well:
Its only the 3rd measure which is the difference between the 1st and 2nd that don't seem to work properly. Any idea on this?
Hello Koushikrish
If the result is incorrect, it may be a problem with the measure. Can you share the code of measure and more details about column? Only these screenshots are hard to judge.
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.
Best Regards,
Community Support Team _ Janey
Sorry for the delay in response. We were able to figure out a solution from your response here above.
Instead of incorporating the WAMP Sort Order on a separate local table, we included it as part of the 'MACO-Brand' table itself on the Remote model (the one as DirectQuery on the Composite model). Once that was done, we used that Sort Order field instead for the sorting and it seems to have fixed our initial problem. Thanks for your help on this!!