Forum Discussion

Quakker's avatar
Quakker
Helper II
3 years ago

Filter on multiple Columns / Values - Data Consolidation

Hi All, i´m struggeling to create a Costcenter Report, where some kind of consolidation has to be done. Attached you can see some sample data.   What i want to achieve is: If a User selects...
Need Help
Quakker's avatar
Quakker
Helper II
3 years ago

Hi Xiaoxin,

i just tried your sultion but it doesn´t seem to work.

Above you can see the results within Power BI. There are Costs about 643.827.

My expectation is that there are TOTAL Costs about 550.560 and CHARGES about 93.267

 

 

Do you know whats wrong?
Best regards and already thanks for your help!

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Quakker,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

  • Quakker's avatar
    Quakker
    Helper II
    3 years ago

    Hi Xiaoxin,

    we were still not able to find a solution.

    Currently we are not sure if it is even possible to create such a measure.

    I´ve attached some sample data. Unfortunatley it was not possible to upload it as a table.

    Already thanks for your help and best regards!

     

    COSTCENTER;AMOUNT;MONTH;SOURCEOBJECT;COSTELEMENT;CONSOLIDATION;HIERARCHY
    43960654;92531,88;1;43960552;6600250000;;TOTAL_COSTS
    43960654;52374,15;1;43960551;6600250000;;TOTAL_COSTS
    43960654;406388,97;1;;6600260000;;TOTAL_COSTS
    43960552;736;1;43960654;6520000001;;TOTAL_COSTS
    43960552;684,54;1;43960655;6520000016;;TOTAL_COSTS
    43960552;91111,46;1;;4020110000;;TOTAL_COSTS
    ;-92531,88;1;43960552;8888888888;43960654-43960552;TOTAL_COSTS
    ;92531,88;1;43960552;9999999999;43960654-43960552;CHARGES
    ;-52374,15;1;43960551;8888888888;43960654-43960551;TOTAL_COSTS
    ;52374,15;1;43960551;9999999999;43960654-43960551;CHARGES
    ;-736;1;43960654;8888888888;43960552-43960654;TOTAL_COSTS
    ;736;1;43960654;9999999999;43960552-43960654;CHARGES
    ;-684,54;1;43960655;8888888888;43960552-43960655;TOTAL_COSTS
    ;684,54;1;43960655;9999999999;43960552-43960655;CHARGES