Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DAX measure not working

Weighted Average Spread = DIVIDE([ANI*SPREADCURRENT], SUM('Pipeline'[ANI])) So I've been using this DAX measure on the same report and same visuals for the past few weeks however, this morning w...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , check, seem like datatype of one of the column has changed or updated . Check the columns below the measure. Under column tools . when you click on column it will show.

     

    Also check data type in power query. Or check any datatype error in power query

    correct that and make it number data type

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , check, seem like datatype of one of the column has changed or updated . Check the columns below the measure. Under column tools . when you click on column it will show.

 

Also check data type in power query. Or check any datatype error in power query

correct that and make it number data type

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you so much! That helped correct everything.

    However, I haven't touched that formula or table in a while so I dont understand why it would suddenly change?