How to create expression for display BS Stock Amount ?

Question

Hi All&nbsp;I have create a column for filter GL Code = 50010 :-1_B_STK = SWITCH(TRUE(),'GL'[GL Code]&gt;=50010 &amp;&amp;'GL'[GL Code]&lt;=50010,"STK",BLANK())&nbsp;May i know how to create an expression for compute the Stock Amount ?&nbsp;&nbsp;&nbsp;&nbsp;Paul Yeo&nbsp;&nbsp;&nbsp;

jdbuchanan71 · Accepted Answer

admin11&nbsp;
Try this.
Stock Amount = 
CALCULATE(
    [AMOUNT],
    GL[1_B_STK] = "STK"
)
&nbsp;

Forum Discussion

How to create expression for display BS Stock Amount ?

1 Reply

Related content

Help!!! Expression Error

Regular expression

Creating a "Display Folder" to group measures.

DAX expression for Max Date data display in Table

Expression Error