DAX for a field that can be used to populate the total storage capacity purchased on an order

[Anupal]

Hello Experts,

I am looking for a field that can be used to populate the total storage capacity purchased on an order.

On the below table, Capacity and capacity_type is as of now calculated using some left/right/mid functions within the TD query.

If any of you have any details on this, please let me know.

Thanks

AP

[Greg_Deckler · Accepted solution]

@Anupal Seems like maybe a column like:

Total capacity = 
  VAR __mult = IF([capacity_type]="TB",1000,1)
RETURN
  [capacity] * __mult