Hi,
This is a question regarding the dynamic segmentation pattern which is as follows using Customers as an example:
I’ve just made aware that in one of my model, the result remains exactly the same when we remove the “> 0”
Can any one explain why we should use this > 0 in this pattern?
Thank you
Di Best
I am definitely not a DAX superstar like some of the folks in this community, but I’ve never seen a pattern like that using “>0”. What I have seen (and used myself) is “+0” which forces the value returned by the COUNTROWS() function to be 0 instead of a blank value when there are no rows that match the criteria. Whether or not that is necessary (or even desirable) in your use case will depend on how/where your measure is being used.
Hi @DiBest
Please read the following post, that is about the same question
Hi both
Thank you so much for your reply. Really appreciated.
Di Best
