Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)")))))))))))
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |