filtering with a dim table that is not directly related to the fact table

leela77 — Wed, 22 Nov 2023 10:18:38 GMT

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.

Re: filtering with a dim table that is not directly related to the fact table

Rupak_bi — Wed, 22 Nov 2023 19:47:22 GMT

Use countX function. it will work even without relationship as well. else share sample data.

topic filtering with a dim table that is not directly related to the fact table in DAX Commands and Tips

filtering with a dim table that is not directly related to the fact table

Re: filtering with a dim table that is not directly related to the fact table