https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-a-field-that-can-be-used-to-populate-the-total-storage/m-p/2061814#M46537 <P>Hello Experts,</P><P>&nbsp;</P><P>I am looking for a field that can be used to populate the total storage capacity purchased on an order.</P><P>On the below table, Capacity and capacity_type is as of now calculated using some left/right/mid functions within the TD query.</P><P>If any of you have any details on this, please let me know.</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>Thanks</P><P>AP</P> Tue, 07 Sep 2021 12:37:23 GMT Anonymous 2021-09-07T12:37:23Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-a-field-that-can-be-used-to-populate-the-total-storage/m-p/2061814#M46537 <P>Hello Experts,</P><P>&nbsp;</P><P>I am looking for a field that can be used to populate the total storage capacity purchased on an order.</P><P>On the below table, Capacity and capacity_type is as of now calculated using some left/right/mid functions within the TD query.</P><P>If any of you have any details on this, please let me know.</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>Thanks</P><P>AP</P> Tue, 07 Sep 2021 12:37:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-a-field-that-can-be-used-to-populate-the-total-storage/m-p/2061814#M46537 Anonymous 2021-09-07T12:37:23Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-a-field-that-can-be-used-to-populate-the-total-storage/m-p/2061861#M46541 <P>Anonymous</LI-USER>&nbsp;Seems like maybe a column like:</P> <LI-CODE lang="markup">Total capacity = VAR __mult = IF([capacity_type]="TB",1000,1) RETURN [capacity] * __mult</LI-CODE> Tue, 07 Sep 2021 12:59:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-a-field-that-can-be-used-to-populate-the-total-storage/m-p/2061861#M46541 Greg_Deckler 2021-09-07T12:59:48Z