The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
User | Count |
---|---|
26 | |
10 | |
8 | |
6 | |
6 |
User | Count |
---|---|
32 | |
14 | |
10 | |
10 | |
9 |