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 n...
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

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.