Forum Discussion

bourne2000's avatar
bourne2000
Icon for Helper V rankHelper V
4 years ago
Solved

Measure is not working in Table visual

Hi   I am having below data model     Target table and sales table connected through Sales ID. Same with sales Target and salesperson   Target Table as below     Salesperson Tab...
Need Help
Show and Tell
  • PhilipTreacy's avatar
    PhilipTreacy
    4 years ago

    Hi bourne2000 

     

    Try SUM / MAX for the %Target

    %Target = SUM('Sales Table'[Total Sales]) / MAX(Target[Sales Target])

     

    Regards

     

    Phil

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
4 years ago

Hi bourne2000 

 

Try SUM / MAX for the %Target

%Target = SUM('Sales Table'[Total Sales]) / MAX(Target[Sales Target])

 

Regards

 

Phil