Forum Discussion

AV_04's avatar
AV_04
Helper I
3 years ago

DAX Help

 Hi guys,   Requesting your help for a DAX command. PFB the sample tables:   Category  Dist         Value A 0 200 B 100 300 C 0 400 D 300 500 E 0 100 F 400 300 ...
Help
AV_04's avatar
AV_04
Helper I
3 years ago

tamerj1could  you help me with the dax fn?

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    HI AV_04 
    Please try

    =
CALCULATE ( AVERAGE ( 'Table'[dist] ), 'Table'[dist] <> 0 )
    - AVERAGE ( 'Table'[Value] )