Forum Discussion

databeta's avatar
databeta
New Member
8 months ago
Solved

DAX Calculation Issues

Hello,   I am creating a report about quality of products. I have Unique Serial Numbers that could have multiple products and each product has a work order number and Order quantity. I am using a m...
Need Help
  • V-yubandi-msft's avatar
    V-yubandi-msft
    8 months ago

    Hi databeta ,

    Thanks for sharing the screenshots they give a idea of what you're working on.
    However, to understand why the numbers are coming out lower than expected, we’ll need a bit more usable sample data.

    Could you please share

    1. A small sample of your data (around 8–10 rows) in a format that we can copy into Excel plain text or a simple table is fine.
    Please include the key columns like.

    Unit BC, Quality Status, Product No, WO, Order Quantity, Area, etc

    2. The expected results for Tested, Passed, Failed, and Yield % for that sample so we can compare and identify where the calculation is going off.

    This will help us recreate your scenario and suggest the right DAX logic or corrections to your current measures.

     

    Thanks. Looking forward to your sample data.

PhilipTreacy's avatar
PhilipTreacy
Super User
8 months ago

databeta 

 

Please supply your data, preferably the PBIX file.  Very hard to help without it.

 

Phil

  • databeta's avatar
    databeta
    New Member
    8 months ago

    Will this help?

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      8 months ago

      Hi,

      No, it doesn't.  Share data in a format that can be pasted in an MS Excel file.  Show the expected result there.

    • V-yubandi-msft's avatar
      V-yubandi-msft
      Community Support
      8 months ago

      Hi databeta ,

      Thanks for sharing the screenshots they give a idea of what you're working on.
      However, to understand why the numbers are coming out lower than expected, we’ll need a bit more usable sample data.

      Could you please share

      1. A small sample of your data (around 8–10 rows) in a format that we can copy into Excel plain text or a simple table is fine.
      Please include the key columns like.

      Unit BC, Quality Status, Product No, WO, Order Quantity, Area, etc

      2. The expected results for Tested, Passed, Failed, and Yield % for that sample so we can compare and identify where the calculation is going off.

      This will help us recreate your scenario and suggest the right DAX logic or corrections to your current measures.

       

      Thanks. Looking forward to your sample data.