Measure to Count instances based on Selections

a quick note - not only does using a date table like the EDNA one ( link ) make projects like this considerably easier, it also helps to reduce the size of your report.

Please see this post (and the followup responses) from Brian J on why you should have a dedicated date table that is marked as your date table. ( link2 )

the TLDR of the above is - if you are not using a date table that is marked as your date table - Power BI is adding an additional invisible date table for every column in your dataset that has a date… and this will bloat most datasets quite a bit.

3 Likes