DAX: Summarize a total score by two columns

[Anonymous]

Member	Phys	Date	Score
A	Joe	1/1/2018	4
A	Bob	1/1/2018	2
A	Joe	1/2/2018	8
B	Joe	1/1/2018	2
B	Bob	1/2/2018	2
C	Joe	1/1/2018	8

I need to summarize a total score for any given day for any Member for a single day

I need an average of those totals by member, by day

I need to be able to count those totals by day if they reach certain thresholds for by member by day 

I need to see a MAX of those daily totals for any given member.

[anandav · Accepted solution]

@Anonymous,

Check the below article:

https://whatthetechisthat.wordpress.com/2018/02/27/power-bi-dax-allexcept-function/

You should be able to write measures using the examples given in the article.