How to use Column/calculated column with a measure and inside a measure - Please read full query.

[shubh_kush]

Hi Everyone,

I have a column TCO% which has values like 5,10,15,20....till 95. 

I have a measure Base% which again has values like 5,10,15,20....till 95. I am using this measure in a slicer as a Dropdown so that user can select a single value. I want to subtract (TCO% - Base%)/100     (Whatever Base% user selects).

Example, if user selects Base % 30, 

Then, TCO % should evaluate to                   (5-30)/100 

                                                                      (10-30)/100 

                                                                      (45-30)/100

                                                                      (95-30)/100   I will use these values for further calclations

Idea is to make Base % dynamic - user selective and calculates the result. For this, I have created another Measure,

Result = (TCO % - Base%)/100

Since Result is a measure type and Base% is already a measure, I cant use TCO% directly as it is a column. If I use VALUES function, it says multiple values were supplied when single value is expected.

[v-yiruan-msft · Accepted solution]

Hi @shubh_kush ,

Please try to update the formula of measure [Result] as below and check whether it can return your desired result:

Result =( MAX ( [TCO %] ) - [Base%] ) / 100

If the above one is not working, could you please provide the formula of measure [Base%] and the screenshots of related visuals? Thank you.

Best Regards
Rena
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.