Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dax Measure not working on visual

Hi, 

 

I've created a Dax measure to test if I can find the weighted Average of the spread using the ANI/IEA however, to get dummy data I created a new column which multiplies Financed Amount by 2 to give dummy data for the ANI/IEA. 

Then i created a two step Dax measure:

 

1. ANI * Financed amount 

2. Then divided the first Dax measure by the sum of the ANI/IEA

 

However, when inputting this into a visual it will not show up. Any suggestions as to why it will not work?

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    5 years ago

    Changing the data type seemed to make it work for now!

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Changing the data type seemed to make it work for now!

    • v-xiaotang's avatar
      v-xiaotang
      Icon for Community Support rankCommunity Support
      5 years ago

      Hi Anonymous 

      Glad to hear that!😁

       

      if your problem has been solved, could you mark your answer as the solution?

      if problem still persists, pls let me know.😉

       

      Best Regards,

      Community Support Team _ Tang

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