Forum Discussion
Anonymous
5 years agoNot applicable
DAX Measure Assistance
I am looking to create a measure that will return the min value of a filtered group. The group currently is a support table and has no direct relationships with any of the tables. The me...
- 5 years ago
Anonymous
See if this works:
Min Site size by Group = MINX ( SUMMARIZE ( FILTER ( ALL ( Sites1[Site ID] ), NOT ( ISBLANK ( [Total Reading Grouped by Site Size] ) ) ), Sites1[Site ID], "size", [Site Size] ), [size] )Min Site ID by Group = CALCULATE ( MAX ( Sites1[Site ID] ), FILTER ( ALLSELECTED ( Sites1[Site ID] ), [Min Site size by Group] = [Site Size] ) )Total reading for Min Site ID by Group = CALCULATE ( [Total Reading], FILTER ( ALLSELECTED ( Sites1[Site ID] ), [Min Site size by Group] = [Site Size] ) )Min Site ID Text = "Site ID " & [Min Site ID by Group] & " at " & FORMAT ( [Min Site size by Group], "Standard" ) & " sqft is the smallest store in this group with a total reading of " & FORMAT ( [Total reading for Min Site ID by Group], "standard" )I've included the sames calculations to obtain the max site values and text in the attached PBIX file:
- 5 years ago
Anonymous
try:
MINX(FILTER (
ALLSELECTED ( Sites1[Site ID] ),
[Min Site size by Group] = [Site Size]
),[Total reading])
Anonymous
5 years agoNot applicable
Hi VijayP. Sorry I maybe didn't explain properly. The measure I posted shows how I calculate the groups and not the measure to bring back the min values.
I don't have an example of what I have attempted so far to obtain the single min value for the selected group.