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.
I have a slicer to select a Country, and a table with 3 measures based on this slicer. The three measures are: Average Historical ASP, Average Material Cost, and Margin. I am trying to add a 4th measure which finds the minimum value from all values in the Margin column.
The formula I am currently using is:
I would expect that with all Country values selected, it should show 3.27 as Min Margin for all rows in the above. Where am I going wrong?
Solved! Go to Solution.
@colsen12 Try:
Min Margin =
VAR __Table = SUMMARIZE(ALL('Historical ASP'),[Country],"__Margin",[Margin])
VAR __Result = MINX(__Table,[__Margin])
RETURN
__Result
hi @colsen12
Seems on the wrong granularity, try like:
Min Margin =
MINX(
SUMMARIZE(
'Historical ASP',
'Historical ASP'[Country],
'Historical ASP'[PH7]
),
[Margin]
)
@colsen12 Try:
Min Margin =
VAR __Table = SUMMARIZE(ALL('Historical ASP'),[Country],"__Margin",[Margin])
VAR __Result = MINX(__Table,[__Margin])
RETURN
__Result
@Greg_Deckler Thanks that works. Was wondering, if I wanted to measure MINX only for selected Country fields from the slicer, where do I add that in?
Try ALLSELECTED instead of ALL.
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 |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |