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.  🙂
v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

Hi Kmptrgeek ,

 

Sorry for that the information you have provided is not making the problem clear to me. Can you please share more details to help us clarify your scenario?

Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

 

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

 

Best Regards,

Jianbo Li

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

Kmptrgeek's avatar
Kmptrgeek
Frequent Visitor
3 years ago

I have a report that has product information on it (first order date, number of orders, etc.) and one of the metrics is percent of grand total.  All of these metrics works correctly when the product is selected from a list of products (or filter)...but when a product is scanned using the barcode scanning capability, the percent of grand total calculation only uses the scanned product, not the entire dataset.  

 

Does that make more sense?