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...
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!

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

glolge_SLB , A calculated column, can use slicer value. Only measure can use slicer value. So please try a measure

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!