Forum Discussion

G3ruso's avatar
G3ruso
Frequent Visitor
2 years ago

ASIGNAR UN VALOR SI UN CAMPO TIENE DATOS

Hola a Todos estoy desarrollando un panel con ventas de productos  tengo cuatro productos desde el 2020 y encuentro que el producto A se ha vendido en el 2020 2021 y 2022 el producto B  se vendio en ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

G3ruso , Try a mea sure or new column

Calculate(distinctcount(Table[Year]), Allexcept(Table, Table[product]))

 

if the column you have to use this on row.

 

You can use Switch to give new meaning to count

G3ruso's avatar
G3ruso
Frequent Visitor
2 years ago

Thanks Amit I tried your solution but this was the result 

 allways was 3 

 

 I tried using sales  the table show values between 3 and 1 but I cannot understand what  these numbers mean

 

thnaks for you orientation