Error in metric when using drill down on matrix

[Anonymous]

Hi,

Currently I'm showing a matrix with multiple columns (all of them are metrics) where I show some values and I created a metric thath divide tha value over the numbre of boxes (8. Full boxes) to create a KPI (Actual x Box) as the image shows:

but when I use the dril down of the matrix the values inside the line become all 0

[Anonymous]

Hi @Anonymous ,

It is a little difficult to find the cause of problem without sample data, metric formula and the setting of matrix(Rows:? Columns:? Values:?). Could you please provide these information in order to make troubleshooting and find the solution? It is better if you can make sample pbix file(exclude sensitive data) for us. Thank you.

Best Regards

[Anonymous]

Hi @Anonymous here is the link of a sample report, thanks.

https://grchia-my.sharepoint.com/:u:/p/juanmanuel_gonzalez/EQAlNO7Rlm1Jv2wejUD0nxgB3ypEZ7hwkS5IDmMlTAkUDw?e=8Wri5v

[Anonymous]

Hi @Anonymous ,

Please try to create another new measure as below and put it in your matrix to replace the original measure [USD x Box] and check whether that is what you want:

New_USD x Box =
SUMX (
    GROUPBY (
        'P&L Lines',
        'P&L Lines'[Line 1],
        'P&L Lines'[Line 2],
        'P&L Lines'[Line 3],
        'P&L Lines'[Chart of Account]
    ),
    [USD x Box]
)

Best Regards

[Anonymous]

Hi @Anonymous the new metric is not working because now all values are 0. I need that de value of each line gets divided by the number of boxes so for example when I open the line 1. Revenue, the values that appear on the column Actual x Box shoud be for example the value of the line 11. Revenue Flowers Gross (163,091.3) divided by 8. Full Boxes (1,217.8) and the result shoud be 133.92 but it is showing 0, the metric it is only doing the division for the upper level of the hierarchy

When I open the next level of the hierarchy the metric stops doing the division and insted always show 0

Thanks