Forum Discussion

martaredondo's avatar
martaredondo
Icon for Helper II rankHelper II
6 years ago
Solved

Measure in matrix not ok

Hey all,

 

I want to present 2 measures in a matrix per month (one of the measures is a count and another a sum). I have a date table connected with my table and when I put the measures and month names in the matrix, the values are incorrect as they are not the sum for each month:

Can someone jhelp me with this please?

 

Thanks,

Marta

Need Help
  • martaredondo's avatar
    martaredondo
    6 years ago

    Hey guys,

     

    Thanks for your help. I already figure out what happened, I had my date table with date in the format "dd-mm-yyyy 00:00:00" but in my equipment table I had real time (example 06:08:55) so the relationship was only getting the 00:00:00 dates!

     

    Hope you have a nice week,

    Marta

6 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Join is not correct or not there  either with date table or with Equipment Table(if any)

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Marta,

    It seems to me that something is going wrong in the relationships.

    Make sure the date table has an active relationship and that the date fields in both tables are returning the same values.

     

    Kind regards
    Joren Venema

    Data & Analytics Consultant
    If this reply solved your question be sure to mark this post as the solution to help others find the answer more easily. 

  • V-lianl-msft's avatar
    V-lianl-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi martaredondo ,

     

    Make sure that your measures use the correct filter conditions.

    If the problem persists,could you please share sample data and DAX formula or sample pbix?(Please mask any sensitive data before uploading)

     

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

    • martaredondo's avatar
      martaredondo
      Icon for Helper II rankHelper II
      6 years ago

      Hey guys,

       

      Thanks for your help. I already figure out what happened, I had my date table with date in the format "dd-mm-yyyy 00:00:00" but in my equipment table I had real time (example 06:08:55) so the relationship was only getting the 00:00:00 dates!

       

      Hope you have a nice week,

      Marta

      • V-lianl-msft's avatar
        V-lianl-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi martaredondo ,

         

        Thanks for your update. As the issue is resolved.

        Please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

         

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