Dax Measure not working on visual

[Anonymous]

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?

[Anonymous · Accepted solution]

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

[v-xiaotang]

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.