topic Calculated Column Count same table multiple filters in DAX Commands and Tips

Calculated Column Count same table multiple filters

joshua1990 — Sun, 10 Jul 2022 18:27:37 GMT

Hi experts!

I have a table that shows me the status per sales order for specific regions:

Sales Order	Region	Status
100	ADB	Z
101	ADB	Z
100	ADB	X
101	ADB	X
102	PRI	O

Now I would like to create a calculated column that shows me per Sales Order if there is an entry for a Sales Order and Region combination with the value 'X'. If so, all rows with this combination should get TRUE, otherwise FALSE.

How is this possible?

Re: Calculated Column Count same table multiple filters

rodrigosan — Sun, 10 Jul 2022 19:04:36 GMT

Would it be this?

Did I solve your problem?
Please mark as solution so others can find this solution.
https://www.linkedin.com/in/rodrigosanpbi/

Re: Calculated Column Count same table multiple filters

tamerj1 — Sun, 10 Jul 2022 19:25:53 GMT

Hi joshua1990
Please use the following

Flag = NOT ISEMPTY ( CALCULATETABLE ( Sales, ALLEXCEPT ( Sales, Sales[Sales Order], Sales[Region] ), Sales[Status] = "X" ) )

Re: Calculated Column Count same table multiple filters

Jihwan_Kim — Mon, 11 Jul 2022 04:29:37 GMT

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

It is for creating a new column.

Condition CC = VAR _currentsalesorder = Data[Sales Order] VAR _currentregion = Data[Region] VAR _newtablecondition = "X" IN SUMMARIZE ( FILTER ( Data, Data[Sales Order] = _currentsalesorder && Data[Region] = _currentregion ), Data[Status] ) RETURN DIVIDE ( _newtablecondition, _newtablecondition ) + 0