Calculated column conditional count

[Anonymous]

Hi, I have a table and created this column:

When I create a visual table It works fine, as it can bee seen:

It only shows values ("VIEJO";"NUEVO";"ACTUAL") if stock is >0, if it´s not, blank is showed. 

The problem is when I create this table :

It shows "VIEJO", "NUEVO"; "ACTUAL"...it's not considering the conditions...It's like if one stock is found, it shows the value (VIEJO,NUEVO....) for all the rows...I need the condition line by line...if stock<=0, then "" , if stock >0, then  "VIEJO" for "ULTIMO INGRESO" <01/01/2021, "NUEVO" <01/01/2022, "ACTUAL" for the rest...What am I doing wrong?

Thanks in Advance!

[Anonymous]

Hi @Anonymous,

It sounds like you want the calculated column response with filter effects, right?
AFAIK, current power bi does not support it create dynamic calculated column based on filter effect. (they are work on the different data levels and you can't use its child to affect the parent level)
I think you need to create a measure expression which can be interacted with filter effect to instead.

Notice: the data level of power bi.

Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)

Regards,

Xiaoxin Sheng

[amitchandak]

@Anonymous , You can create color measure and use that in conditional formatting using field value option

example

Color Year = if(FIRSTNONBLANK('Table'[Year],2014) <=2016,"lightgreen",if(FIRSTNONBLANK('Table'[Year],2014)>2018,"red","yellow"))

Color = if(FIRSTNONBLANK('Table'[Year],2014) <=2016 && AVERAGE(Sales[Sales Amount])<170
,"lightgreen",if(FIRSTNONBLANK('Table'[Year],2014)>2018,"red","yellow"))
Color sales = if([Sales Today] -[sales yesterday]>0,"green","red")

How to do conditional formatting by measure and apply it on pie? : https://youtu.be/RqBb5eBf_I4

[Anonymous]

Thanks @amitchandak , but it´s not what I asked for... I need the same I explained in the post