Forum Discussion
How to Using Logical Function in DAX and Display the Result with Actual Value
Hi Frnds,
I Created a Measure with existing tables and created a final result. In another Matrix Visual I would like to display the Final Result value which meets the Logical Function of Greater then 0 and Not Required if the Value fields which is less then or equal to 0.
with this Condition I am able to See the Result as below. But I don't want True or False as result.
Please suggest me a DAX Measure.
Aha, then try this:
Pending Dispatch =VAR =_VALUE = SUM(salesproj[projqty])-SUM('Stock and Sales'[Total Sale Qty])-SUM('Stock and Sales'[Total Stock Qty])RETURNIF (_VALUE>0,_VALUE)
4 Replies
FreemanZSuper User
If not True/False, what do you expect?
What about 1 or blank?
Pending Dispatch =IF ( SUM(salesproj[projqty])-SUM('Stock and Sales'[Total Sale Qty])-SUM('Stock and Sales'[Total Stock Qty])>0, 1)Thanks for your reply FreemanZ .
Please see the below snap shot. Want this value instead of True in that condition and Not required the Field which is less then 0 (negative value) or False condition.
Ex: Refer the Column AHM in that want to display only the Row 2,4,6,7 and in AMB column want to display the Row 7,9,13 ....Viceversa... for the False statement column the result can show as blank or empty.
- FreemanZ
Aha, then try this:
Pending Dispatch =VAR =_VALUE = SUM(salesproj[projqty])-SUM('Stock and Sales'[Total Sale Qty])-SUM('Stock and Sales'[Total Stock Qty])RETURNIF (_VALUE>0,_VALUE)
