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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

grggmrtn , try a measure like

countx(filter(summarize(Table,table[personID], "_1", calculate(distinctcount(Table[Service]),Table[Service] in {"A","B"})),[_1] =2),[personID])

 

display only personId and Week

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

    And.. what am I supposed to do with this measure?

     

    Displaying only PersonID and week isn't going to work either, because the value (price per week) is per service - so I need to display the service as well