Abu Dhabi Power BI User Group

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  How can i calculate grandtotal in matrix visual

    Posted Oct 27, 2021 02:55 AM
    Hello everone here!
    I created a visual in which i want to calculate grandtotal its not matching with grand total of excel file with same measure and values
    pictures are attached below
    kindly support in this regard


    ------------------------------
    muhammad zain
    Junior Bi developer
    ------------------------------


  • 2.  RE: How can i calculate grandtotal in matrix visual

    Top Contributor
    Posted Oct 28, 2021 03:56 AM
    Hi,
    It's impossible to help you with the description and the information you provided.
    No dataset, no measures, no .pbix file and the images shows nothing
    The problem could be anything, the data themselves or maybe you added a slicer

    ------------------------------
    If any discussion or answer help, please mark it as "Recommend"
    ------------------------------

    Best regards
    Mehdi HAMMADI

    MCT | MCSA BI Reporting | MCSE Data Management and Analytics | Data Analyst Associate
    2019 Ruby Award Dynamic Communities
    ------------------------------



  • 3.  RE: How can i calculate grandtotal in matrix visual

    Gold Contributor
    Posted Nov 04, 2021 08:55 PM
    Hi Mohammad,

    You can check the filters applied to these visuals, to the page or the measure itself. if anything checked or filter, definitely will change the totals and math.

    Anyway, could you clarify your questions to help us understand your issue.

    Thank you.

    ------------------------------
    S B
    Data Manager
    ------------------------------