Forum Discussion

glolge_SLB's avatar
glolge_SLB
Frequent Visitor
2 years ago
Solved

Change calculated column using Numeric range parameter

I have created a new column using the numeric range parameter (0,1,0.1). When i created the numeric range parameter, it had to be given default value which i provided as 0.7. The calculated column is correct. When i change the value of the parameter, the calculsted column is not updating. 

Numeric range parameter 

 

Calculated column,

 

When i change the defualt value of 0.7 to other value the calculated column get updated. But the calculated column does not update when i change the numeric range parameter using the assigned slicer

 

Slicer of Numeric range parameter

Would greatly appreciate any help. I have spent too much time trying to solve this. 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi glolge_SLB 

     

    Calculated columns cannot be dynamicly updated according to the numeric range slicer. Only measures can do that. Based on your description, I made an example as below. The first measure is to compare a value with the threshold value. The second one is to sum up the 1s for every date. 

    TrueComp = IF(SELECTEDVALUE('Table'[Complete]) >= [Threshold Value], 1, 0)
    No. of TrueComp = SUMX(VALUES('Table'[Date]),[TrueComp])

     

    Hope this would be helpful. If you cannot get what you want, you may provide some dummy data and expected outcome, we can then help to provide a more detailed solution. 

     

    Best Regards,
    Jing
    If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

     

3 Replies

    • glolge_SLB's avatar
      glolge_SLB
      Frequent Visitor
      2 years ago

      Thanks Amit,

      The Calculated column is going to be 0s and 1s and i am using the this in a Line and Clustered column chart with Date befing x axis. I need result for each month/quarter/year. 

       

      I tried the measure option but not able to find a way to use iterative aggregator to sum up the 1s for each row. 

       

      Calculation measure  - need to find a way to iterative agreegate 

       

      Alternatively, i was thinkning of creating three columns in query table using different thresholds and using SWITCH to create a calculated column based on sliser selection.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi glolge_SLB 

         

        Calculated columns cannot be dynamicly updated according to the numeric range slicer. Only measures can do that. Based on your description, I made an example as below. The first measure is to compare a value with the threshold value. The second one is to sum up the 1s for every date. 

        TrueComp = IF(SELECTEDVALUE('Table'[Complete]) >= [Threshold Value], 1, 0)
        No. of TrueComp = SUMX(VALUES('Table'[Date]),[TrueComp])

         

        Hope this would be helpful. If you cannot get what you want, you may provide some dummy data and expected outcome, we can then help to provide a more detailed solution. 

         

        Best Regards,
        Jing
        If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!