Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
The following measure yeilds the maximum Planned Capacity for all years rather than my intended maximum Planned Capacity for a given / single year. For example, the maximum Planned Capacity for 2023 = 28 and the maximum Planned Capacity for 2024 = 26. This measure always yeilds 28. Can someone help with what I am doing wrong? Thanks.
Solved! Go to Solution.
Hi @DAXHeadroom ,
You can try the following dax:
Planned Capacity Measure =
MAXX(
FILTER(ALLSELECTED('Planned Capacity Table'),
'Planned Capacity Table'[Year]=MAX('Table'[Year])),[Planned Capacity])
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @DAXHeadroom ,
You can try the following dax:
Planned Capacity Measure =
MAXX(
FILTER(ALLSELECTED('Planned Capacity Table'),
'Planned Capacity Table'[Year]=MAX('Table'[Year])),[Planned Capacity])
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Jihwan_Kim Thank you for the reply. Unfortunatley, this measure yeilds the same result (28 in the example above).
Below is an example of my table.
The table is related to a Date Table (Weekday to Weekday) and I have Year, Month and Weekday Slicers based on the Date Table. Regardless of selection (or deselection) of any/all Slicers, the result is always 28.
Any help is appreciated.
Base | Weekday | Planned Capacity | Weekday Number | Month | Year |
ABC | Tuesday | 28 | 3 | January | 2023 |
ABC | Tuesday | 26 | 3 | January | 2024 |
Hi,
Please try something like below whether it suits your requirement.
Planned Capacity Measure =
MAXX (
ADDCOLUMNS (
SUMMARIZE ( 'Planned Capacity Table', 'Planned Capacity Table'[Year] ),
"MAXCapacity", CALCULATE ( MAX ( 'Planned Capacity Table'[Planned Capacity] ) )
),
[MAXCapacity]
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
User | Count |
---|---|
54 | |
23 | |
19 | |
18 | |
17 |
User | Count |
---|---|
91 | |
86 | |
46 | |
28 | |
22 |