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.
Hey all,
I'm struggling to find a solution in order to calculate a measure which provide the cusmized Max I need. In particular, I need the monthly max for each Division to show it in a graph, but i also want to get the maximum considering more than one division (that i choose on the slicer). Example below: I want power BI to calculate what the sum of daily sales for division A and B and provides the max for each month.
I managed to calculate the max per monthy for each division by creating a column, but it does not allow me to provide customized maximums depending on what I select.
Please find there the .pbix and the excel and let me know if you know how to do it!
Thanks!
Solved! Go to Solution.
@u92690 , try a measure like
maxx(values(date[Date]), calculate(sumx(Table, divide([A],[B]))))
Superb! Thanks!
@u92690 , try a measure like
maxx(values(date[Date]), calculate(sumx(Table, divide([A],[B]))))
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 |
---|---|
105 | |
102 | |
79 | |
72 | |
65 |
User | Count |
---|---|
141 | |
107 | |
100 | |
82 | |
74 |