Measure in matrix not ok

[martaredondo]

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

[V-lianl-msft]

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 · Accepted solution]

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]

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.

[Greg_Deckler]

Could be a measure totals problem. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

[Anonymous]

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. 

[amitchandak]

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