After filtering in A choose min sales per ID in B and summarize them

[annamakarova]

Hello!
I have dataset with product IDs, competitors and sales.
In Power BI I need to make like "dynamic recalculation" after user choose competitors.

1. User choose competitors (a & c);

2. Need to find minimum sales per IDs (for ID 1 it will be 12, for ID 2 - 2);

3. Then summarize found sales (12 + 2).

The problem is that I understand how  to do it for constant dataset (for all competitors) with SQL, Python, but how to make it recalculated depends on competitor's choose?

Appreciate any help, as I am newcomer in Power BI world...

Anna

[Jihwan_Kim]

Hi, @annamakarova 

Please check the below picture and the sample pbix file's link down below.

Result Measure =

VAR groupbyIDtable =

GROUPBY (

ALLSELECTED ( Data ),

Data[ID],

"@minsales",

MINX (

CURRENTGROUP (),

Data[sales]

)

)

RETURN

SUMX (

groupbyIDtable,

[@minsales]

)

https://www.dropbox.com/s/vlt0juf0h3ihmtg/annamakarova.pbix?dl=0 

[annamakarova]

Dear @Jihwan_Kim , thanks a lot!

But how to make it works for different categories?
So in Result Measure there is total sum of minimum sales per ID is shown for category A, B, C separately?

[Jihwan_Kim · Accepted solution]

Hi, @annamakarova 

Please check the below.