Forum Discussion
Solved
DAX Measure
I have a senario in Power BI that I can't seem to figure out. I have a table with various loan data, i.e. interest rate, UPB, DTI, etc. I also have a column with historical price these loans sold a...
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 ,
how Z is calculated based on the 3 red slicers? Is Z the maximum of the slicer "LTV"?
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