cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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. 

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

 

COUNTROWS(
    GROUPBY (
        Fact_Table,
        'Customer'[Customer Name],
        'Store'[Store Name],
        'Product'[Item ID]
)
)
1 REPLY 1
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: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

Regards,

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.