Power BI中聚合分箱的度量值ID计数获取方法求助

Hey there! Let's work through this issue together. It sounds like you’ve got your base measures (Product Count and Amount Total) set up, and you’ve created binning bands using SWITCH—but you’re stuck on counting how many unique IDs fall into each of those bands. Here’s how to fix this:

First, let’s confirm your band measures (example structure) #

I’ll assume your band measures look something like this (adjust the thresholds to match your actual logic):

Product density band = 
SWITCH(
    TRUE(),
    [Product Count] < 5, "Low Density",
    [Product Count] >= 5 && [Product Count] < 10, "Medium Density",
    [Product Count] >= 10, "High Density"
)

Amount band = 
SWITCH(
    TRUE(),
    [Amount Total] < 1000, "Small Amount",
    [Amount Total] >= 1000 && [Amount Total] < 5000, "Medium Amount",
    [Amount Total] >= 5000, "Large Amount"
)

Solution 1: Create a dynamic measure for ID counts per band #

If you want an interactive measure that works directly in your visuals (like a bar chart or table), use CALCULATE + COUNTROWS to lock in the band context:

ID Count per Product Band = 
VAR CurrentBand = [Product density band]
RETURN
CALCULATE(
    COUNTROWS(DISTINCT(table[ID])), // Use COUNT(table[ID]) if IDs are unique per row
    ALLSELECTED(table),
    FILTER(
        ALLSELECTED(table),
        // Replicate your SWITCH logic here to match the current band
        SWITCH(
            TRUE(),
            [Product Count] < 5, "Low Density",
            [Product Count] >= 5 && [Product Count] < 10, "Medium Density",
            [Product Count] >= 10, "High Density"
        ) = CurrentBand
    )
)

Repeat this pattern for the Amount band by swapping out the band logic.

Solution 2: Build a calculated table for static analysis #

If you prefer a static table that precomputes all bands and their ID counts, use SUMMARIZE to group IDs by their bands:

Binned ID Summary = 
SUMMARIZE(
    table,
    table[ID],
    "Product Density Band", [Product density band],
    "Amount Band", [Amount band]
)

Then, add a simple measure to count IDs in this table:

Total IDs per Band = COUNTROWS(Binned ID Summary)

You can now use this table in visuals by dragging the band fields to rows/columns and the Total IDs per Band measure to values.

Quick Tips #

• If your ID column has no duplicates per row, replace COUNTROWS(DISTINCT(table[ID])) with COUNT(table[ID]) for better performance.
• Make sure your visuals are filtered correctly—use ALLSELECTED instead of ALL if you want to respect any slicers or filters applied to your report.

内容的提问来源于stack exchange，提问作者Pratham