Forum Discussion
DAX Measure
Hi azale2407 ,
see my new pbi file. I have created a new table and a new slicer for Loan Number that is not going to affect the calculation of the variable Z.
https://1drv.ms/u/s!Aj45jbu0mDVJi3BPJZwKA7Yqf21J?e=Je4U6u
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi azale2407 ,
see my pbi file
https://1drv.ms/u/s!Aj45jbu0mDVJi3BPJZwKA7Yqf21J?e=P6iWwk
Is this your expected result?
or you want to calculate first an average value for Loan number 21 in column [Price Sold]?
Yes, the first table has my desired Yield correct. Not sure I see how your power bi file answers how to do this though.
So basically, I ultimately want a scorecard to simily populate the Yield (in this case the correct result would be .04706)... but as I adjust the red slicers in my power bi.... the price of "85" would dynamically adjust because of the filters and ultimately change the yeild result. Does that make sense?