Forum Discussion

Nou_admin1's avatar
Nou_admin1
Frequent Visitor
3 years ago
Solved

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 ...
Help required
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    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])
    RETURN
    IF (_VALUE>0,_VALUE)
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

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])
RETURN
IF (_VALUE>0,_VALUE)
Nou_admin1's avatar
Nou_admin1
Frequent Visitor
3 years ago

Thanks FreemanZ , I got what I expect from your Answer.  Thank you so much.