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!

     

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!