Forum Discussion

Dd_diamond's avatar
Dd_diamond
New Member
2 years ago
Solved

Why Date dimensions table not working with measures

  Whenever i try to put the Field    "Total Patient " = CountRows('Hospital ER') With the month in matrix or line chart unable to show valus only the total         
Date
PowerBI DAX
  • Anonymous's avatar
    Anonymous
    2 years ago

     Hi,   Dd_diamond 

    Based on your information, I create tables:

     

     

     

    This is my model relationship:

     

     

    I think your error is due to an error of the Date type in your Hospital ER table, and I get the same error as you when my type is Text instead of the Date type.

     

    If I correct it to type Date, then he will display correctly, here is my preview

     

     

     

     

    How to Get Your Question Answered Quickly 

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data)

    Best Regards

    Yongkang Hua

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

 Hi,   Dd_diamond 

Based on your information, I create tables:

 

 

 

This is my model relationship:

 

 

I think your error is due to an error of the Date type in your Hospital ER table, and I get the same error as you when my type is Text instead of the Date type.

 

If I correct it to type Date, then he will display correctly, here is my preview

 

 

 

 

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data)

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.