Forum Discussion

Rahulsingh's avatar
Rahulsingh
Icon for Helper I rankHelper I
7 years ago

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's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft 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