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)
Nou_admin1's avatar
Nou_admin1
Frequent Visitor
3 years ago

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'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.