Forum Discussion

xanderdiederen's avatar
xanderdiederen
Frequent Visitor
7 years ago

Calculating measures based on different hierarchy levels

Hi All,   I'm pretty new to the world of PowerBI and have a problem with a certain measure that i'm trying to create.  I have several consumer goods that are classified into different level of cat...
Need Help
TeigeGao's avatar
TeigeGao
Icon for Solution Sage rankSolution Sage
7 years ago

Hi xanderdiederen ,

Could you please share the sample data and expected result to explain your requirement? Actually, we can create multiple separate tables for Category levels, these tables can be used for slicer, then use selectedvalue to judge which value is selected.

Best Regards,

Teige

  • xanderdiederen's avatar
    xanderdiederen
    Frequent Visitor
    7 years ago

    EDIT: updated the link to the file, I have a separate mapping for 'time' that i now also included in the uploaded file.

     

     

     Hi TeigeGao 

     

    Thanks for your reply! i've upload a data sample PBI file in the following link

     

    What you can see there as well is that for certain data rows (so certain months) in the raw data, there is no more 'cost' data for a certain product type. 

    E.g. say there is 'cost' data for the months Jan - Apr but not for May and June but there is 'volume' data for the months Jan - June. The measure i'm trying to calculate (Deflated YTD) then gets zero'd out completely eventhough it it should be recalculated with the additional volumes on a year to date base.

     

    In case of unclarities please let me know!

     

    Thanks again!