Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Error with aggregate percentage

Hello all,

From the screenshot below, I would expect the Actual Daily headcount % to be around 30% for the month of February. But, it comes out to be around 56%. I am unable to figure out how 56% is being calculated. 

Any help would be appreciated .

 

 

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , share measure formula 

     

    If this does not help
    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

       

       

      Hello, these are the DAX used.

      1.For Actual daily HC

      emp count = DISTINCTCOUNT('Epay Punches'[employeeNumber])

      2. For the target daily HC
      Sum of Max Target Daily Heads = SUMX(
      ADDCOLUMNS(
      SUMMARIZE(
      'Epay Punches',
      [before sep 1],
      [shift]
      ),

      "MaxDailyHeads",
           MAXX('target headcount',[max target daily head])
      ),
      [MaxDailyHeads]
      )
      3. Actual daily HC%= 
      ActDailyHc% = DIVIDE('Epay Punches'[emp count], 'Epay Punches'[Sum of Max Target Daily Heads])