Considering a ORDERS table, have customer_id, product_id, order_date columns.
In SQL, if we want to know
how many customers ordered a specified number of different products,
we could write the query like this:
count( customer_id ) customer_cnt
count( distinct product_id ) product_cnt
from orders a
group by a.customer_id ) a
I'm wondering how to achieve this in power bi with DAX.
What I want is a dynamic table, not a static derived static table. Means the output will change when the date filter is applied.
Go to Solution.
You may take a look at the following post.
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!