Change calculated column using Numeric range parameter

[glolge_SLB]

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. 

[amitchandak]

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

[glolge_SLB]

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.

[v-jingzhan-msft · Accepted solution]

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!