Forum Discussion

saad_mce's avatar
saad_mce
Icon for Helper I rankHelper I
4 years ago
Solved

Does calculate work with virtual table/columns

Hi all, I am trying to measure how many products in a factory achieved the production plan in a certain month. Monthly production plan table is divided into daily plans in a different table. For the...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi saad_mce 
    To be honest I did not fully read your requirement. Only the part the states the problem with the grand total. I did not understand the need for the virtual table in the "Plan Achievement2" measure Why don't you just use the calculation straight away? 

    Plan Achievement2 :=
SUM ( 'Actual_Production'[Actual Production] )
    / SUM ( 'ZLTP_Prod_Jan22_Daily'[Qty/Day] )

    For the other measure measure just use

    SKUs Achieved 1 New:=SUMX ( VALUES ( New_MSAUDIT[Material] ), [SKUs Achieved 1] )