Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 ...
Need Help DAX
  • ERD's avatar
    ERD
    5 years ago

    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.

ERD's avatar
ERD
Icon for Community Champion rankCommunity Champion
5 years ago

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.