Forum Discussion

Babycakes's avatar
Babycakes
Helper II
3 years ago

VAR MEASURE rewrite

HI all

 

I have the following dax that I am trying to finetune to another table

 

FROM:

SOS =

var _client_name = SELECTEDVALUE('PocketWatch Shift Invoice Repor'[Client name])

var _product_code = SELECTEDVALUE('PocketWatch Shift Invoice Repor'[NDIS Support Item number])

var _sos = CALCULATE(SUMX('GENIUS Schedule of Support Expo','GENIUS Schedule of Support Expo'[SOS Units]),

           'GENIUS Schedule of Support Expo'[Client Name]  = _client_name,

           'GENIUS Schedule of Support Expo'[Product code] = _product_code

        )

return _sos

 

 

To

 

 

Can you assist me on how to alter?

 

Thank you

Need Help
Tips and Tricks

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi  Babycakes ,

     

    You can try the following dax:

    SOS =
var _client_name = SELECTCOLUMNS('PocketWatch Shift Invoice Repor',"client_name",[Client name])
var _product_code = SELECTCOLUMNS('PocketWatch Shift Invoice Repor',"product_code",[NDIS Support Item number])
var _sos=
CALCULATE(SUM('GENIUS Schedule of Support Expo'[SOS Units]),
FILTER(ALL('GENIUS Schedule of Support Expo'),
'GENIUS Schedule of Support Expo'[Client Name] in _client_name &&
'GENIUS Schedule of Support Expo'[Product code] in _product_code))
return
_sos

     

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Babycakes's avatar
      Babycakes
      Helper II
      3 years ago

      APologies, I meant as in with the new column names on the 2nd image 🙂