Forum Discussion
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...
nmck86
Post Patron
Post PatronCALCULATE(
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
Hello, unfortunately this will not work. I think a better way to illustrate the problem I have is if I lay out my table horizontally.
Keep in mind this is just for illustrative purposes: My table is vertical and not horizontal as shown above.
Other thing was that the end user wants to plan based on Project Finalized date slicer so they can plan whats coming up for Q2, Q3 for example.