Forum Discussion
DAX Measure Help
Hi All,
I have below dataset and i want to plot values present in column: Capacity in the visual.
| RailHead | Carrier | Capacity | Inventory | Inv_LinkDate |
| RH1 | C1 | 100 | 30 | 01-Sep-2021 |
| RH1 | C2 | 100 | 40 | 02-Sep-2021 |
| RH2 | C3 | 200 | 40 | 01-Sep-2021 |
| RH2 | C4 | 200 | 40 | 02_Sep-2021 |
Cpacity is associated with RailHead. Each RailHead can have multiple Carrier associated with It.
Now if i select RailHead: RH1 from Filter then Capacity for 01-Sep-2021 and 02-Sep-2021 will be: 100
Similarly if i select additional RailHead:RH2 from filter then Cpacity will be 300 (Total Sum of capacity for all selected RailHead) on 01-Sep-201 and 02-Sep-2021
Please help in creating DAX measure for above scenario.
Thanks in advance
Thanks
Hi Anonymous ,
Not sure about all the prerequisites, but you can try the measure below:
capacity_amt = SUMX(DISTINCT(T[RailHead]), CALCULATE(MAX(T[Capacity])))If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.
2 Replies
- ERD
Community Champion
Hi Anonymous ,
Not sure about all the prerequisites, but you can try the measure below:
capacity_amt = SUMX(DISTINCT(T[RailHead]), CALCULATE(MAX(T[Capacity])))If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.