Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
@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.
User | Count |
---|---|
102 | |
91 | |
87 | |
78 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |