DAX Measure Help

[Anonymous]

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

[ERD · Accepted solution]

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.

[Anonymous]

Thanks! your logic worked, its returning correct result.