Forum Discussion

grggmrtn's avatar
grggmrtn
Icon for Post Patron rankPost Patron
6 years ago
Solved

AND 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...
Need Help
  • Fowmy's avatar
    Fowmy
    6 years ago

    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 🙂



    YouTube
    LinkedIn

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi grggmrtn ,

 

Not very clear.

 

You can try SUMMARIZE (Table,Table[id], Table[Sevice])

 

 

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)