Forum Discussion
DAX Count total based on a measure
I have two matrix tables, one with the properties, in it shows the count of total residents that make up money owed in that property. In the matrix below it, the resident detail from the property se...
Hi RE_AM ,
Make sure both matrices are run under the same filter context, especially regarding attribute selection and date period.
Try not adding the filter: "DATESINPERIOD ('Tenant AR'[As of] , MAX ('Tenant AR'[As of]), -1, MONTH )". See if the problem still exists.
Please provide me with test data, not in the form of screenshots, please remove any sensitive data in advance.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!