Forum Discussion

pankajgurav's avatar
pankajgurav
Regular Visitor
1 year ago
Solved

Total Row counts by category

Hi I have the data shown below: Which holds the user's timesheet data. Each user has 52 timesheets per year, and it shows how many are submitted on time or not. For total timesheet count, i have use...
Need Help
  • quantumudit's avatar
    quantumudit
    1 year ago

    Hello pankajgurav 

    Thank you for providing a sample dataset and demonstrating the expected results. The following DAX measures can be used

     

    To calculate the total timesheets:

    Timesheet Count = SUM(Timesheets[No of timesheet])

     

    To calculate total timesheet by username (irrespective of sumbitted or, not)

    Total Timesheets = 
CALCULATE(
    [Timesheet Count],
    ALL(Timesheets[Timesheet Submitted on Time])
)

     

    The following GIF demonstrates various slicer selections; however, total timesheet count remains unaffected by the selection of "Y" or "N".

     

     

    Best Regards,
    Udit

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudo 👍

    🚀 Let's Connect: LinkedIn || YouTube || Medium || GitHub
    ✨ Visit My Linktree: LinkTree

     

    Proud to be a Super User

     

     

     

     

quantumudit's avatar
quantumudit
Icon for Super User rankSuper User
1 year ago

Hello pankajgurav 

Thank you for providing a sample dataset and demonstrating the expected results. The following DAX measures can be used

 

To calculate the total timesheets:

Timesheet Count = SUM(Timesheets[No of timesheet])

 

To calculate total timesheet by username (irrespective of sumbitted or, not)

Total Timesheets = 
CALCULATE(
    [Timesheet Count],
    ALL(Timesheets[Timesheet Submitted on Time])
)

 

The following GIF demonstrates various slicer selections; however, total timesheet count remains unaffected by the selection of "Y" or "N".

 

 

Best Regards,
Udit

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudo 👍

🚀 Let's Connect: LinkedIn || YouTube || Medium || GitHub
✨ Visit My Linktree: LinkTree

 

Proud to be a Super User

 

 

 

 

pankajgurav's avatar
pankajgurav
Regular Visitor
1 year ago

Hi quantumudit ,

 

Thanks for your reply. I calculated a total of 52 timesheet entries using the below formula 

 

Total Timesheet Count = CALCULATE( COUNTROWS('Timesheet'), FILTER(ALLSELECTED('Timesheet'),'Timesheet'[Timesheet Submitted on Time]<>"ABC"))

 

I have applied the identical formula that you have provided, yet the outcome remains unchanged.

 

Thanks,

Pankaj

 

Thanks

  • quantumudit's avatar
    quantumudit
    Icon for Super User rankSuper User
    1 year ago

    Hello pankajgurav 

    I trust you've used a measure rather than a calculated column. If the solution is still not working, we'll need to examine the data model. Sharing a sample dataset and details about any existing relationships would be extremely helpful.

     

    I've also attached the Power BI file I used to address your query. Please review it and let me know if you see anything I might have overlooked.