How to modify that measure to be for more than single column?

[Pbiuserr]

Hello,

I've got a measure like down below which let's me compare values from two categories if I use two slicers from separate tables

SalesAmountComparison = CALCULATE( [SalesAmount],  FILTER(ALL(Fct_Tbl[Category]), Fct_Tbl[Category] IN ALLSELECTED('New Fct_Tbl'[Category] ) )

I'd like to add to that measure couple of other columns, like Country, Brand, Color but don't know how to insert it properly into the measure or if its possible. Or do I need to create separate for each and then SWITCH(True()) ?

[Anonymous]

Hi @Pbiuserr ,

You could use "&&" or "||".

"&&" means and, "||" means or.

For example:

calculate(sum(column),filter(table,conditon1&&condition2&&condition3))

If I misunderstood your meaning, please share more details.

Best Regards,

Jay

[Pbiuserr]

Hi,

If it concerns one table then its fine, but my each filter would be from different table

[Anonymous · Accepted solution]

Hi @Pbiuserr ,

You could use multiple FILTER() functions in CALCULATE() function.

Like:

CALCULATE(<expression>[, <filter1> [, <filter2> [, …]]])

Best Regards,

Jay

[amitchandak]

@Pbiuserr , if they are two fact tables then you join to create a common dimension and join with facts for filter

refer if  my blog on the same can help

https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solutio...