Forum Discussion
Georgiaoc
2 years agoRegular Visitor
Why is my MIN function ignoring 0?
Hi there! I've found a few posts asking how to exclude zero from MIN caluclations but I'm having the opposite problem! I've used the following expression: MIN = CALCULATE(MIN('TABLE'[VARIABLE]...
Georgiaoc
2 years agoRegular Visitor
Thank you!
So turns out my original expression techincally works - a variation of the one you provided above also works too.
HOWEVER! It seems the problem is actually something within Power BI table behaviour - if I look at raw scores within a table, these do show that some individuals have a MIN score of 0, however, when they're summarized into a group within a table, it shows 1 as the MIN value. Do you understand the logic for this?
Screenshot below shows an example of a group with 4 people in it - with row level detail on the right that shows that some of these people do indeed have a MIN of 0.
JamesFR06
Resolver IV
2 years agoDifficult without tables in front.
DPV_MIN is it a rounded result ?