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 ,

 

When you scanned, the visuals will be filtered by the product barcode you scanned.

What is the % Grand Total calculated and does it vary depending on the item scanned? Or it is a fixed value?

You can try to use some filter functions like REMOVEFILTERS() to remove the Barcode's filter.

If that does not work, please provide me with more details about your table and the relationships between your tables or share me with your pbix file after removing sensitive data.

 

Here are some Documnents, please check if these could help you a little:

Filter functions (DAX) - DAX | Microsoft Docs

REMOVEFILTERS function (DAX) - DAX | Microsoft Docs

 

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

The REMOVEFILTERS command will not work in my case because I'm am accessing the tables via Direct Connection.  I understand how the barcode scanning functionality works as far as filtering the visuals, I just don't understand how to write the DAX to get it to apply my calculation to the entire dataset instead of just what was scanned.  This DAX works when I filter to a specific product:

 

% Grand Total of Volume = DIVIDE(SUM(SUB_SETTLED_SALES[VV998_Q_PHYSICAL_CASES]) ,
 (CALCULATE(SUM(SUB_SETTLED_SALES[VV998_Q_PHYSICAL_CASES]),                               allselected(BAS_MDM_UNITED_CUSTOMER[CUSTOMER_ID]), ALL(BAS_MDM_UNITED_PRODUCT)) ))
 
My pbix file is massive and will take forever to remove the sensitive data.  This "seems" pretty straightforward to me as far as what the issue is.  It has nothing to do with the table schemas or anything like that...it's the DAX.  Why is it working with the filters in the report but not with the barcode scanner?
 
Thank you for any assistance.