Forum Discussion

naelske_cronos's avatar
naelske_cronos
Icon for Advocate II rankAdvocate II
9 months ago
Solved

Handle AverageX on different granularities matrix drilldown

Hello,   I have a matrix in Power BI where you can drill down to different granularities, from region on top to customer level (3 levels). The problem is that when drilling down, my averageX is no...
"DAX " "DAX help" 'Need help'
  • naelske_cronos's avatar
    naelske_cronos
    9 months ago

    Hello,

     

    The question has not been resolved but I have found a workaround using bookmarks and seperate measures for each level of hierarchy. I guess the problem lies in the hierarchy context for the totals for which a single measure is "impossible" to use.

     


    Kind regards

     

    Kevin

Anonymous's avatar
Anonymous
Not applicable
9 months ago

Hi naelske_cronos 

 

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.


Thank you

naelske_cronos's avatar
naelske_cronos
Icon for Advocate II rankAdvocate II
9 months ago

Hello,

 

The question has not been resolved but I have found a workaround using bookmarks and seperate measures for each level of hierarchy. I guess the problem lies in the hierarchy context for the totals for which a single measure is "impossible" to use.

 


Kind regards

 

Kevin

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 months ago

    Hi naelske_cronos ,

    We really appreciate your efforts and for letting us know the update on the issue.

    Please continue using fabric community forum for your further assistance.


    Regards