Forum Discussion
Error in metric when using drill down on matrix
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
4 Replies
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
Hi Anonymous here is the link of a sample report, thanks.
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