I didn't know about 0 and blank being equal. Can you tell me how to force it in a slicer? For example, I have values (0, 1, 2, 3, 4) in slicer, When I select 0, it filters on 0 and blanks
You can use the strict evaluation == in your measure or create a measure to apply in visual level filter. It’s hard give answers without seeing the file, you share a dummy file with sample data explaining the desired outcome info@excelfort.com
DAX has a deep learning curve. You need to clearly understand certain basic concepts such as evaluation context, context transition and dimensional model then others are just applications of these concepts. I spent time solving small problems and learnt gradually. Refer to this resource there are many more on the web: docs.microsoft.com/en-us/dax/dax-learn-videos