Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hi, @annamakarova
Please check the below.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, @annamakarova
Please check the below picture and the sample pbix file's link down below.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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?
Hi, @annamakarova
Please check the below.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |