Forum Discussion
Last visit filter depending on date (part II)
Hi, So we come from here; https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Variable-column-depending-on-filters/m-p/3191794 The original need was to get a Last visit filter: N...
Hi Anonymous ,
After long time research, I'm still not quite clear about your sample and purpose. As your description "I have tried removing the "&& [Presence of our product] = "NO"" part", but why not remove it, here's the result of remove the part.
Best regards,
Community Support Team_yanjiang
Hi v-yanjiang, thanks for your answer and I apologize if i didnt make myself clear.
The measure, as you stated above in your picture, works, but it is not correct. For instance, the correct number of "No"s is 232 as I showed in my sample, not 242. Also, if you check your numbers in the table, they dont add up 242+215+2 is not 445. Correct number is NO= 232 + YES = 211 BLANK=2, and that is 445!
Hope I cleared it out.