Forum Discussion
KNP
Super User
Super UserMeasure with Disconnected Table as Filter
TLDR
I suspect this will be easy for someone with a better understanding of DAX (currently my weakest skill set, work in progress) and that hasn't been staring at the problem for hours.
This ...
parry2kSuper User
Super UserKNP if you see the diagram below, based on your sample data, In the red box, a new measure I provided, yellow highlighted your original measure, and Card visual showing total summary days and total matches everywhere. Something else is going on with your real model since you mentioned there are a lot more columns in the table, if you trim down your table to just 3 columns that you gave in the example and then test the measure, what do you get?
it is hard to debug what is going on with partial information