Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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...
Need Help
v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
3 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.