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.
Here is an example....
- I need to create a measure to show Yield where:
(X * Y) / (X * Z) = Yield
- Z is dynamically changing as the three red bordered slicers are adjuested
- X and Y are exact values of the loan number selected in the blue slicer
- Loan 21 is new and has no price yet. So want to find yield where price is average of similar historical loan
Hi azale2407 ,
how Z is calculated based on the 3 red slicers? Is Z the maximum of the slicer "LTV"?
No, Z is simply the average of Price. There are 3 slicers simply filter what values are included. i.e. LTV between 70-85, DTI between 35-45, and Rate between 4-4.5.... but obviously i need those ranges to be dynamic and easily chnaged. 3 slicers are my filters.... then after filtered... Z is simply average price.
Here is a link to download both the excel file and the sample power bi file. Let me know if you need anything else.
Excel - https://righthousecapital.sharefile.com/d-s5dfd3e35bf8248dcb6a961ebed752b8a
Power BI - https://righthousecapital.sharefile.com/d-sb72c40a14f2f4297a124f42aec1ec997