Showing results for 
Search instead for 
Did you mean: 
mriccardi Frequent Visitor
Frequent Visitor

Optimize Countrows - GroupBy

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. 



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 Smiley Sad


        'Customer'[Customer Name],
        'Store'[Store Name],
        'Product'[Item ID]
Community Support Team
Community Support Team

Re: Optimize Countrows - GroupBy

Hi @mriccardi ,

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:



Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.