How to show dynamic measures on a chart using the slicer option

[Camillanaep]

Hello everybody!

I have a query on my BI wich contains the columns:

Name of owner    Error      Situation

Paul                       1,0%

Maria                     5,4%

Laura                     2,1%

Pedro                    1,4%

Louis                     0,6%

This column "Situation" is a condicional column that tells me if this error is "OK" or "NOT OK". >>> If(Error>X; "Not OK"; "OK")

But sometimes this X (acceptable error) is 5%, sometimes is 4%, sometimes is 3%, sometimes is 2% and sometimes is 1%. 

So, i need to create a slicer with this values of X (5%, 4%, 3%, 2%, 1%), and when i click, for example, in 5%, my  situation column tells me if the Error is OK or NOT OK.

Can somebody help me?

[v-yulgu-msft]

Hi @Camillanaep,

Suppose source table is named as Table1, an other table which contains slicer itmes (5%, 4%, 3%, 2%, 1%) is named as Table2.

You can create a measure as below:

Measure = IF(MAX(Table1[Error])>MAX('table2'[X]),"Not OK","OK")

Best regards,
Yuliana Gu

[Camillanaep]

And do you know how can i transform this measure to a column? I need to create charts and work with this information

[Ashish_Mathur]

Hi,

As far as i know, that is not possible.  A slicer selection cannot recompute a calculated column.  It can only recompute a calculated field i.e. measure.

[Ashish_Mathur · Accepted solution]

Hi,

You may refer to my solution here.

Hope this helps.