Forum Discussion

PrakharJain21's avatar
PrakharJain21
New Member
6 years ago
Solved

How to calculate Distribution with Drop Size using PowerBi Reports?

My data has date-level, customer-level, product level invoicing data and I often have to count the number of customers where the following criteria is fulfilled:   Operation: Count of customers for...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI,

     

    try with this one:

     

    # Customers Prod A > 10 =
    COUNTX(
        FILTER(
            CALCULATETABLE(
                SUMMARIZE(
                    Sales,
                    Sales[CustomerID],
                    "Product A Sales",
                    SUM(Sales[Sales])
                ),
                Sales[Product Type] = "Product A"
            ),
            [Product A Sales] >= 10
        ),
        [CustomerID]
    )
     
    Regards
    Lorenzo
Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI,

 

try with this one:

 

# Customers Prod A > 10 =
COUNTX(
    FILTER(
        CALCULATETABLE(
            SUMMARIZE(
                Sales,
                Sales[CustomerID],
                "Product A Sales",
                SUM(Sales[Sales])
            ),
            Sales[Product Type] = "Product A"
        ),
        [Product A Sales] >= 10
    ),
    [CustomerID]
)
 
Regards
Lorenzo
PrakharJain21's avatar
PrakharJain21
New Member
6 years ago

Thanks a lot! That worked well!