Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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])+0)
I would have try this :
MIN = CALCULATE(MIN('TABLE'[VARIABLE]))
return
if(isblank(min),0,Min)
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.
Difficult without tables in front.
DPV_MIN is it a rounded result ?
HI
I think these topics can help you
https://community.fabric.microsoft.com/t5/Desktop/DAX-treats-0-as-BLANK-how-to-prevent-it/m-p/342272
Hi there! Thanks for your reply! Unfortuntately, I had already reviewed those resources and didn't find them helpful. If you have other suggestions, I'd really appreciate it! Thanks 😄
User | Count |
---|---|
65 | |
46 | |
20 | |
18 | |
15 |
User | Count |
---|---|
119 | |
41 | |
40 | |
28 | |
22 |