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.

gmsamborn's avatar
gmsamborn
Icon for Super User rankSuper User
1 year ago

Hi Kopek 

 

Would it be possible to replicate the problem using sample data in a pbix that you would be able to share?

 

Also required would be the definitions for [Current], [Demand], and [Average] (and any other required measures) as well as their underlying tables.

 

https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523