Forum Discussion

JosePintor's avatar
JosePintor
Frequent Visitor
7 years ago

MATRIX GrandTotal calculation with TOPN multiples dimensions in same column (measure)

Hi everybody,   I have a similar issue with calculate GrandTotal over a TOPN list that changes with drilldown of 4 dimensions. how can i SUM only the visibles TOP5 values refering to the correspon...
Need Help
  • JosePintor's avatar
    JosePintor
    Frequent Visitor
    7 years ago

    Hi Lydia,

     

    Here's the link to the excel file with sample data an all explanations to the issue.

    Sample Data

     

    Thanks in advance.

     

    Jose Pintor

    • MattAllington's avatar
      MattAllington
      Community Champion
      7 years ago

      Jose


      You need to post a PBIX file that contains the problem, otherwise those that are trying to help you have to first rebuild the workbook to re-create the problem.  Please post a sample PBIX that generates the problem as you have described.