Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello.
I would like to COUNTROWS in the fact_ga_sessions table, however, I need filters from dim_ga_page, dim_ga_cart and dim_ga_session.
It looks like I need FILTER, RELATEDTABLE, CALCULATETABLE(?), however, I am not quite sure how.
I would appreciated any help on this one.
Note: A relationship could be created between dim_ga_page and fact_ga_session, however, it'll break other measures, that's already in there. I explicitly look for a DAX measure solution.
Use countX function. it will work even without relationship as well. else share sample data.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 6 | |
| 6 | |
| 4 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 24 | |
| 17 | |
| 10 | |
| 7 | |
| 6 |