Forum Discussion
Post PatronAND filter based on ID and date
grggmrtn
Maybe this?Measure = VAR A = CALCULATE( COUNTROWS(VALUES(Data[Service])), ALLSELECTED(Data[Service]) ) RETURN IF( A > 1, SUM(Data[Value]), BLANK() )________________________
If my answer was helpful, please mark this post as a solution, this will also help others!.
Click on the Thumbs-Up icon if you like this reply š
Post PatronYour matrix looks like the one I already have, and you've run into the same problems that I ahve.
Person 1 - you have values listed for Service A for weeks 14 and 15. Since there is no Service B for those weeks, your value shouldn't be displayed.
And what would happen if you have a PersonID 4 that only has Service A? They would also show up in that matrix - but that's what I'm trying to avoid.
I need to show PersonID that have BOTH, per weeknr
Super Usergrggmrtn
Maybe this?
Measure =
VAR A =
CALCULATE(
COUNTROWS(VALUES(Data[Service])),
ALLSELECTED(Data[Service])
)
RETURN
IF(
A > 1,
SUM(Data[Value]),
BLANK()
)
________________________
If my answer was helpful, please mark this post as a solution, this will also help others!.
Click on the Thumbs-Up icon if you like this reply š