Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Counting with restriction

I have a base with documents that have multiple occurrences that are listed line by line, as shown in the table below:   Document Occurrence   12345 left over 12345 missing 23456 (another o...
Need Help
Tips and Tricks
Tutorial Requests
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    Anonymous  Please try this as a New Column to flag the missing occurrences of the documents.

     

    Flag = 
VAR _Count= CALCULATE(COUNT(Test223Lkp[Occurrence]),FILTER(Test223Lkp,Test223Lkp[Document]=EARLIER(Test223Lkp[Document]) && Test223Lkp[Occurrence] <> EARLIER(Test223Lkp[Occurrence])))
RETURN IF(_Count>0,"Y","N")

PattemManohar's avatar
PattemManohar
Community Champion
7 years ago

Anonymous  Please try this as a New Column to flag the missing occurrences of the documents.

 

Flag = 
VAR _Count= CALCULATE(COUNT(Test223Lkp[Occurrence]),FILTER(Test223Lkp,Test223Lkp[Document]=EARLIER(Test223Lkp[Document]) && Test223Lkp[Occurrence] <> EARLIER(Test223Lkp[Occurrence])))
RETURN IF(_Count>0,"Y","N")