topic Re: Error - The expression refres to multiple columns - assistance ? in DAX Commands and Tips

Error - The expression refres to multiple columns - assistance ?

suvechha — Tue, 09 Nov 2021 23:01:03 GMT

Hi there ,

Please kindly assist me with the below query -

The expression was working , I need to put the if clause - when trying the if clause got the error

Nominated COVID Wards - Occupied Bed = if ( Facility="NBH","NA", CALCULATE( SUM(COVID_OCP[count_ward_positive]),FILTER(DATE_CONSOLIDATION_TMP,DATE_CONSOLIDATION_TMP[datetype]=13),FILTER(DATE_CONSOLIDATION_TMP,DATE_CONSOLIDATION_TMP[Last_n_days]=0),FILTER(COVID_OCP,COVID_OCP[count_ward_designated]=1)) )

Error image

Re: Error - The expression refres to multiple columns - assistance ?

VahidDM — Tue, 09 Nov 2021 23:29:02 GMT

Hi suvechha

What is Facility in your code? is that column, var, or measure?

Appreciate your Kudos!!

Re: Error - The expression refres to multiple columns - assistance ?

suvechha — Wed, 10 Nov 2021 00:16:59 GMT

its dimension column

Re: Error - The expression refres to multiple columns - assistance ?

VahidDM — Wed, 10 Nov 2021 10:35:33 GMT

Hi suvechha

Try this:

Nominated COVID Wards - Occupied Bed = IF( MAX( Facility ) = "NBH", "NA", CALCULATE( SUM( COVID_OCP[count_ward_positive] ), FILTER( DATE_CONSOLIDATION_TMP, DATE_CONSOLIDATION_TMP[datetype] = 13 && DATE_CONSOLIDATION_TMP[Last_n_days] = 0 ), FILTER( COVID_OCP, COVID_OCP[count_ward_designated] = 1 ) ) )

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/