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"?
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.