Forum Discussion

Kopek's avatar
Kopek
Icon for Helper IV rankHelper IV
1 year ago

Variable changes the outcome

Hi!   I have built the following measure, and wanted to otimize it with variable, but ufortunately it does not work as expected. When variable is used i am missing totals from the table, and the o...
Kopek's avatar
Kopek
Icon for Helper IV rankHelper IV
1 year ago

Hi DataNinja777 , thanks for trying to help, but unfortunately your solution makes the same error as mine -no total in the table and different outcomes per ID than original measure.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Kopek ,

 

I think you can try ALL() or ALLSELECTED() function to check whether it could show Total.

Your issue is based on your data model, I suggest you to share a sample file with us and show us a screenshot with the result you want.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.