Forum Discussion
grggmrtn
Post Patron
Post PatronAND filter based on ID and date
I need to isolate data for PersonID that have two specific values (in two different rows, of course), per week. PersonID that only have one of the values need to be ignored. I've created a matrix ta...
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 🙂
Fowmy
Super User
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 🙂
