Forum Discussion
Urgent - Issue with Range bins- Please help
Hi Everyone
I have a calculated column for range bin which is based on a measure stored in a column. The problem I am running into is that when a user changes the date slicer it does not calculate based on measures as we know calculated columns only get recalculated only on refresh and slicer do not apply to the calculated column.
How can I covert this Range Bin column into a Measure or do something else so it can respond to measures calculations as they change the slicer. Please see screenshots
Calculated Column = MortgageLTV = IF(RELATED('_TDS Loans'[Actual CalculatedLTV])<.50 ,"Mortgage with LTV < 50%" ,IF (AND (RELATED('_TDS Loans'[Actual CalculatedLTV]) >= 0.50 ,RELATED('_TDS Loans'[Actual CalculatedLTV]) <0.55 ),"Mortgage with LTV ( 50% to 55%)",IF(AND (RELATED('_TDS Loans'[Actual CalculatedLTV]) >= 0.55 ,RELATED('_TDS Loans'[Actual CalculatedLTV]) <0.60 ),"Mortgage with LTV ( 55% to 60%)",IF (AND (RELATED('_TDS Loans'[Actual CalculatedLTV]) >= 0.60 ,RELATED('_TDS Loans'[Actual CalculatedLTV]) <0.65 ),"Mortgage with LTV ( 60% to 65%)",IF(AND (RELATED('_TDS Loans'[Actual CalculatedLTV]) >= 0.65 ,RELATED('_TDS Loans'[Actual CalculatedLTV]) <0.70 ),"Mortgage with LTV ( 65% to 70%)",IF (AND (RELATED('_TDS Loans'[Actual CalculatedLTV]) >= 0.70 ,RELATED('_TDS Loans'[Actual CalculatedLTV]) <0.75 ),"Mortgage with LTV ( 70% to 75%)",IF (AND (RELATED('_TDS Loans'[Actual CalculatedLTV]) >= 0.75 ,RELATED('_TDS Loans'[Actual CalculatedLTV]) <0.80 ),"Mortgage with LTV ( 75% to 80%)",IF (AND (RELATED('_TDS Loans'[Actual CalculatedLTV]) >= 0.80 ,RELATED('_TDS Loans'[Actual CalculatedLTV]) <0.85 ),"Mortgage with LTV ( 80% to 85%)",IF (AND (RELATED('_TDS Loans'[Actual CalculatedLTV]) >= 0.85 ,RELATED('_TDS Loans'[Actual CalculatedLTV]) <0.90 ),"Mortgage with LTV ( 85% to 90%)",IF (AND (RELATED('_TDS Loans'[Actual CalculatedLTV]) >= 0.90 ,RELATED('_TDS Loans'[Actual CalculatedLTV]) <0.95 ),"Mortgage with LTV ( 90% to 95%)",IF (AND (RELATED('_TDS Loans'[Actual CalculatedLTV]) >= 0.95 ,RELATED('_TDS Loans'[Actual CalculatedLTV]) <1 ),"Mortgage with LTV ( 95% to 100%)","Mortgage with LTV (100% Plus)")))))))))))
1 Reply
- v-jiascu-msft
Microsoft Employee
Hi Rahulsingh,
Please share a sample file. Please mask the sensitive first. Your data here is a result. We don't know where the date column and how it will filter the column.
Best Regards,
Dale