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

tex628's avatar
tex628
Icon for Community Champion rankCommunity Champion
5 years ago

Hi, 

Sounds like something has occured in your sourcedata within the [ANI] column. I'd start by going into power query and making sure that you convert the column into a numeric datatype. If this returns an error there should be a value within the column that is incorrect. 

/ J