Forum Discussion

Kmptrgeek's avatar
Kmptrgeek
Frequent Visitor
3 years ago
Solved

% Grand Total using barcode scanner

I have a report that is working great with the barcode scanner...but my calculation for % Grand Total doesn't work when the product is scanned, only when it is selected from a table or other visual o...
Need Help
  • Kmptrgeek's avatar
    Kmptrgeek
    3 years ago

    I think I have solved my issue.  In the DAX I've written I am filtering by all selected customers and all products.  When I modified my DAX to be the following it looks like the calculations are working with the scanner.  

     

    % Grand Total of Volume = DIVIDE(SUM(SUB_SETTLED_SALES[VV998_Q_PHYSICAL_CASES]) ,
     (CALCULATE(SUM(SUB_SETTLED_SALES[VV998_Q_PHYSICAL_CASES]), ALL()) ))
     
    Now I just have to figure out why my RANKX code isn't working with the scanner.  🙂
Kmptrgeek's avatar
Kmptrgeek
Frequent Visitor
3 years ago

I think I have solved my issue.  In the DAX I've written I am filtering by all selected customers and all products.  When I modified my DAX to be the following it looks like the calculations are working with the scanner.  

 

% Grand Total of Volume = DIVIDE(SUM(SUB_SETTLED_SALES[VV998_Q_PHYSICAL_CASES]) ,
 (CALCULATE(SUM(SUB_SETTLED_SALES[VV998_Q_PHYSICAL_CASES]), ALL()) ))
 
Now I just have to figure out why my RANKX code isn't working with the scanner.  🙂