Forum Discussion
grggmrtn
Post Patron
Post PatronDISTINCTCOUNT per category, using relation
Hey everyone - having a bit of a problem getting the data I need. Here's my data: PersonID DateRegistered StartDate 1 01-01-2020 01-01-2020 1 02-01-2020 03-02-2020 1 03-02-2020 0...
grggmrtn
Use your measure and modify as follows:Antal indskrivninger = SUMX( SUMMARIZE(Table,Table[PersonID],Table[StartDate]), CALCULATE( DISTINCTCOUNT('Table'[StartDate]), USERELATIONSHIP(Table[StartDate],Dato[Date]) ) )________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
Fowmy
Super User
Super Usergrggmrtn
Use your measure and modify as follows:
Antal indskrivninger =
SUMX(
SUMMARIZE(Table,Table[PersonID],Table[StartDate]),
CALCULATE(
DISTINCTCOUNT('Table'[StartDate]),
USERELATIONSHIP(Table[StartDate],Dato[Date])
)
)________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
