- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @suvechha
What is Facility in your code? is that column, var, or measure?
Appreciate your Kudos!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
its dimension column
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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/
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
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.
Subject | Author | Posted | |
---|---|---|---|
05-31-2024 01:21 PM | |||
06-05-2024 02:19 AM | |||
06-13-2024 07:52 AM | |||
10-11-2024 03:15 AM | |||
05-13-2024 11:21 AM |
User | Count |
---|---|
13 | |
12 | |
12 | |
8 | |
7 |
User | Count |
---|---|
16 | |
13 | |
11 | |
11 | |
9 |