Forum Discussion

aditya_141228's avatar
aditya_141228
Icon for Helper I rankHelper I
2 years ago
Solved

Need Help with Aging Report

I've been working on this Inventory Aging Report,  Here Base, Chemicals, Concentrate Chemicals are Item and every Item has multiple Products. The data that is coming here on Item Level for eac...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    Hi,

    This measure will get the correct figure for Z_aging Qty < 30.  See the last column in the image

    Measure = SUMX(VALUES('Aging Main'[Product]),[Z_Aging Qty <30])

    Hope this helps.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi aditya_141228 ,

Suggested Solutions:

1. Review Context Transition: Ensure that the DAX expressions correctly handle context transitions when moving from item group aggregations to product-level details. This includes verifying that the CALCULATE function is being used appropriately to modify filter contexts as needed.

 

2. Verify Aggregation Logic: Double-check the logic used for aggregating sales and purchase quantities, especially how the date filters are applied. It's crucial that the aggregation logic aligns with the hierarchical data model of item groups and products.

 

3. Total Calculation Review: For the total calculation issue, ensure that the DAX expression for totals is correctly scoped to include all relevant data points across both item groups and products. This might involve revisiting how totals are calculated and ensuring that the aggregation encompasses all necessary levels of data.

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.