Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Is there a way to display the Max value of a column on a dashboard when there exists a Year filter?
DATE_OPENED | TTC |
4/8/2020 0:00 | 0 |
4/7/2020 0:00 | 0 |
4/7/2020 0:00 | 0 |
4/7/2020 0:00 | 0 |
4/4/2020 0:00 | 4 |
4/4/2020 0:00 | 5 |
4/6/2020 0:00 | 0 |
4/2/2020 0:00 | 0 |
4/2/2020 0:00 | 4 |
4/1/2020 0:00 | 8 |
4/3/2020 0:00 | 0 |
4/6/2020 0:00 | 0 |
For example, in the dataset above, if the year 2020 was selected on my Chicklet filter, I would want the Card output to say "8"
Please let me know if this question does not make sense
Thank you!
Sarah
Solved! Go to Solution.
@Anonymous
smth like
= CALCULATE(MAX('Table'[TTC]), ALLEXCEPT(Table, Table[DATE_OPENED].[Year]))
Hi @Anonymous
in verycommon case just
= CALCULATE(MAX('Table'[TTC]))
will give desired result
@az38 , This gives the Max of the whole column, but I want it to display the Max of multiple years... so for example if the Max is 8 in 2020, I want all 2020 dates to display "8" but if the max is 13 in 2019, I would want it to display "13"
thank you!
Sarah
@Anonymous
smth like
= CALCULATE(MAX('Table'[TTC]), ALLEXCEPT(Table, Table[DATE_OPENED].[Year]))
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |