Forum Discussion

suvechha's avatar
suvechha
Icon for Helper IV rankHelper IV
4 years ago
Solved

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 ...
  • VahidDM's avatar
    VahidDM
    4 years ago

    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/

     

     

VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
4 years ago

Hi suvechha 

 

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

 

Appreciate your Kudos!!

 

suvechha's avatar
suvechha
Icon for Helper IV rankHelper IV
4 years ago

its dimension column

 

  • VahidDM's avatar
    VahidDM
    Icon for Super User rankSuper User
    4 years ago

    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/