Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

DAX Measure error need to add values or format to countrows

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])
))
 
Need Help
  • PVO3's avatar
    PVO3
    3 years ago
    CALCULATE(
      COUNTROWS(RTT),
      RTT[Actual_Weeks_Waiting] IN {"Admitted", "Non Admitted"},
      REMOVEFILTERS('Table_Switch'[Selection])
    )
     

     

  • Anonymous's avatar
    Anonymous
    3 years ago
    CALCULATE(
      COUNTROWS(RTT),
      RTT[Actual_Weeks_Waiting] IN {"Admitted", "Non Admitted"},
      REMOVEFILTERS('Table_Switch'[Selection])

5 Replies

  • PVO3's avatar
    PVO3
    Icon for Impactful Individual rankImpactful Individual
    3 years ago
    CALCULATE(
      COUNTROWS(RTT),
      RTT[Actual_Weeks_Waiting] IN {"Admitted", "Non Admitted"},
      REMOVEFILTERS('Table_Switch'[Selection])
    )
     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi PVO3 - still getting the following error message

       

      • PVO3's avatar
        PVO3
        Icon for Impactful Individual rankImpactful Individual
        3 years ago

        What measure do you use?

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