Forum Discussion

POWER_MI's avatar
POWER_MI
Post Patron
5 years ago
Solved

Color column conditions

Hi All, in the source table  it's like this  In the Power BI three mesure are calculated based on this table :   Mesure_1_NBR_R1= CALCULATE(     COUNTA('table'[column]),     'table'[co...
Need Help
POWER_MI's avatar
POWER_MI
Post Patron
5 years ago

hi amitchandak 

 

Column "Measure_1_NBR_R2" in table "Table" could not be found and is not used in this expression.

Column "Measure_1_NBR_R1" in table "Table" could not be found and is not used in this expression.

Column "Measure_1_NBR_R3" in table "Table" could not be found and is not used in this expression.

 
POWER_MI's avatar
POWER_MI
Post Patron
5 years ago

Hi amitchandak 

i send error when doing with swhich is not blanck.

to be clear 

The begening condition is to color windows of values witch is the number of 'R1, nmber of R2 at differents step:

So the if condition will be 

If Step 1 and status R1  the color of values "Number of R1 will be RED. 

the number of R1 is calcultated with mesure

Mesure_1_NBR_R1

CALCULATE( COUNTA('tabla'[column]), 'table'[column] IN "R1"
and same alos for R2.
Also for example 
for step 1 and Step 6 the color of Number of values will be different so why it's mandatory to have conditions like swhich condition or if .. and not regulare or concrete values because the color of our windows number of values will be different on step 1 and step 6 or 7. 
For example Number of R1 is Red on step 1 but will be orange on Step 7 ( if step =7 number of R1 value windows will be orange)
hope that it s clear thanks for help