Dynamic grouping based on the parameter

[rawmeat]

Hello all,

I am trying to use dynamic grouping to display the total sales based on low, medium and high unit price.

The grouping table is like this.

I also used some dax expression to do the classification.

Dynamic price grouping = 
CALCULATE (
    [Total Sales],
    FILTER (
        'Sales Data',
        COUNTROWS (
            FILTER (
                'Groups for Pricing',
                'Sales Data'[Unit Price] >= 'Groups for Pricing'[Min Price]
                    && 'Sales Data'[Unit Price] < 'Groups for Pricing'[Max Price]
            )
        )
            = 1
    )
)

My question is that Is there a way to dynamically change the min Price or Max Price based the parameter put by the user?

For example, if the user pus 500 as min price it will give 500 for the min price.

Thank you

Zhongyang 

[v-xjiin-msft · Accepted solution]

@rawmeat

In your scenario, you need to add parameters in the DAX expression to replace the fixed low, medium or high unit price. So that users can change the parameters dynamically. Right?

However, as I know for current Power BI, referencing parameters is currently supported via the Data Source dialogs, Filter Rows, Keep Rows (top/bottom, etc.), Remove Rows (top/bottom, etc.) and Replace Values. So I'm afraid it is not supported to use a parameter in measure or calculated column. 

If you have concern on this feature, I would suggest you to submit your idea here.

Thanks,
Xi Jin.

[rawmeat]

Thank you for the information.