Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone!
I want to optimize a measure that I´ve calculated but I´m getting trouble trying to get the same result with different coding approaches.
In my data model I have something like this:
Fact_Table connected to Product dimension, to Time dim, Customer dim, Stores dim.
I want to calculate how many unique products I have in the combination Customer - Stores.
Example:
Customer A
-Store A: 4 unique products.
-Store B: 6 unique products.
Customer B
-Store 01: 10 unique products.
-Store 02: 4 unique products.
When adding in a Table visual Customer Name + Measure I should see:
Customer A: 10
Customer B: 14
I´ve managed to get this result doing this but performance sucks 😞
COUNTROWS( GROUPBY ( Fact_Table, 'Customer'[Customer Name], 'Store'[Store Name], 'Product'[Item ID] ) )
Hi @Anonymous ,
Could you please post some simple sample data and your desired result to have a test if possible? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Regards,
Daniel He
User | Count |
---|---|
98 | |
91 | |
84 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |