Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Grand Total not showing correctly

    Posted Apr 08, 2022 07:28 PM
    Hello, I am developing a Training Report to show different visuals for trainings, One of the visuals is to show the number of Training taken by each department,

    When I show the total number it's showing 213 training, However, when i convert it to a chart and add a department, the breakdown of departments shows a different total number of trainings.

    I have 3 Tables in the Model, 1 For Employee Information, 1 for training, and 1 for Training taken by Employees, linking them with the Training ID and Employee ID.


    Can you advise why the breakdown is showing a different number than the total? i have tried to use a measure to distinct the count but still the same issue. i tried looking online but can't figure it out or if there is an issue in my model and relationship

    Thank you very much in advance

    ------------------------------
    Osama Ashraf
    Jr Data specialist
    ------------------------------


  • 2.  RE: Grand Total not showing correctly

    Posted Apr 10, 2022 07:58 PM

    Hi Osama,

    When I have a problem with totals/sums usually it's problem with filters/context filters.
    Or with relations.

    Regards.



    ------------------------------
    Adam Artur Boltryk
    Business Analyst
    ------------------------------



  • 3.  RE: Grand Total not showing correctly

    Posted Apr 14, 2022 03:00 PM
    Edited by Rukiatu Collier Apr 15, 2022 10:22 AM

    Hi Osama,

    To get the correct total you may have to create a measure with SUMX function, see repro below:


    Also check out my blog post: https://rukiatu.com/average-in-power-bi-vs-excel/

    ------------------------------
    Ruki Collier
    Data Scientist
    ------------------------------