Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

DAX Measure error need to add values or format to countrows

‎10-10-2022 07:51 AM

Hi Experts

 

Cannot see my error on where to add values or format inorder to countrow the rows
Measure =

CALCULATE(sum(RTT[Pathway]),RTT[Actual_Weeks_Waiting] IN {"Admitted", "Non Admitted"}),REMOVEFILTERS('Table_Switch'[Selection])
))
 
Labels:
Message 1 of 6
514 Views
0
2 ACCEPTED SOLUTIONS
PVO3
Impactful Individual
Impactful Individual

‎10-10-2022 07:53 AM
CALCULATE(
  COUNTROWS(RTT),
  RTT[Actual_Weeks_Waiting] IN {"Admitted", "Non Admitted"},
  REMOVEFILTERS('Table_Switch'[Selection])
)
 
PVO3_0-1665413706259.png

 

View solution in original post

Message 2 of 6
510 Views
Anonymous
Not applicable
In response to PVO3

‎10-10-2022 08:10 AM
CALCULATE(
  COUNTROWS(RTT),
  RTT[Actual_Weeks_Waiting] IN {"Admitted", "Non Admitted"},
  REMOVEFILTERS('Table_Switch'[Selection])

View solution in original post

Message 5 of 6
464 Views
0
5 REPLIES 5
PVO3
Impactful Individual
Impactful Individual

‎10-10-2022 07:53 AM
CALCULATE(
  COUNTROWS(RTT),
  RTT[Actual_Weeks_Waiting] IN {"Admitted", "Non Admitted"},
  REMOVEFILTERS('Table_Switch'[Selection])
)
 
PVO3_0-1665413706259.png

 

Message 2 of 6
511 Views
Anonymous
Not applicable
In response to PVO3

‎10-10-2022 08:01 AM

Hi PVO3 - still getting the following error message

Checkers111_0-1665414054309.png

 

Message 3 of 6
505 Views
0
PVO3
Impactful Individual
Impactful Individual
In response to Anonymous

‎10-10-2022 08:08 AM

What measure do you use?

It appears like you're still using SUM, or your RTT[Actual_Weeks_Waiting] is not a text field.

Message 4 of 6
469 Views
0
Anonymous
Not applicable
In response to PVO3

‎10-10-2022 08:15 AM

solved ignore previous post - thanks

Message 6 of 6
459 Views
0
Anonymous
Not applicable
In response to PVO3

‎10-10-2022 08:10 AM
CALCULATE(
  COUNTROWS(RTT),
  RTT[Actual_Weeks_Waiting] IN {"Admitted", "Non Admitted"},
  REMOVEFILTERS('Table_Switch'[Selection])
Message 5 of 6
465 Views
0

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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

View All