Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Filter Data based on a specific row value

Hello,   I have a table with a list of milestones for each project in a vertical manner along with the milestone date and status. I want to be able to filter to specific projects from the table bas...
Need Help
nmck86's avatar
nmck86
Post Patron
7 years ago

CALCULATE(
COUNT('TBL'[PROJECT_CD] ),
'TBL'[PROJECT_CD] = "1000")+CALCULATE(
COUNT('TBL'[PROJECT_CD] ),
'TBL'[PROJECT_CD] = "1003")

 

may be missing a parenthesis but that should get you the counts for the codes that are equal to 1001 & 1003