In this example I want to expand you mind around the possibilities you have when using the COUNTROWS functions.
You are not just restricted to using COUNTROWS with a physical table. You can also use virtual tables that contain complex logic themselves.
This is a very good review of virtual tables in general and the flexibility you have in Power BI when you use them effectively.
Good luck
Sam
***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn
FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv
FREE – Power BI Resources – https://ift.tt/2LiAVQj
FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95
Learn more about Enterprise DNA – https://ift.tt/2LiAWDR
Enterprise DNA Membership – https://ift.tt/2IJLxWD