Yes or No depending of the Sum

[gomezc73]

Hello,

   I need help with the following issue.

   i Have a table like with total of variations by Family/Color at the end of the year

Balance Family	Color	FISCAL_YEAR	Variance
Bikes	Blue	19	-8000.00
Bikes	Yellow	19	0.00
Bikes	Red	19	-14656.43
Bikes	Blank	19	8000.00
Bikes	White	19	0.00
Bikes	Green	19	14656.43
		Total Variation	0.00
Scooter	Blue	19	10000.00
Scooter	Yellow	19	5000.00
Scooter	Red	19	3000.00
Scooter	Blank	19	-10000.00
Scooter	White	19	-5000.00
Scooter	Green	19	-2950.00
		Total Variation	50.00

I want to display a summary by 'Balance Family' where if the Sum of all variance(by color) is not zero, then Display "Yes" in the cell Varition.

Something like this:

Balance Family	Total Balance	Have Variance
Bikes	0	No
Scooter	50	Yes

Could you please help me?

Regards 

[jthomson]

newmeasure á if(sum[variance]-0,"No","Yes")

Si su columna de varianza es realmente una medida, ponga eso en su lugar

[gomezc73]

No worked, when add the measure YesNo_Sum = if(Sum(File[Variance])<>0,"Yes","No"), the rows are duplicated, one row for each color..

[v-deddai1-msft · Accepted solution]

Hola @gomezc73 ,

Debe sumar en el campo Desviación.

Puede crear medida:

Have Variance = IF(SUM('Table'[Variance]) = 0,"No","Yes")

Para obtener más información, consulte el archivo pbix:https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EZA2DyRJRcJOgET745...

Si este post ayuda, entonces considera Aceptarlo como la solución para ayudar a los otros miembros a encontrarlo más rápidamente.

Saludos

Dedmon Dai