Reply
suvechha
Helper IV
Helper IV

Error - The expression refres to multiple columns - assistance ?

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 
error.PNG
1 ACCEPTED SOLUTION

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/

 

 

View solution in original post

3 REPLIES 3
VahidDM
Super User
Super User

Hi @suvechha 

 

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

 

Appreciate your Kudos!!

 

its dimension column

 

screen.PNG

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/

 

 

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric Community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)