Forum Discussion

DummyBIDev's avatar
DummyBIDev
Frequent Visitor
2 years ago

Number of Days between two dates split by month - Employee Data

Hi All   Hoping you guys can direct me in the right direction, i've spent hours searching the forums and tried various suggesstions but nothing seems to work as i need it to.    This post will be...
Need Help
barritown's avatar
barritown
Icon for Solution Sage rankSolution Sage
2 years ago

DummyBIDev,

Could you please clarify the problem for me with a screenshot or another PBIX file?

On my screenshot the total value is 48 so I don't get your point.

 

DummyBIDev's avatar
DummyBIDev
Frequent Visitor
2 years ago

see screenshot of my visual

 

 

 

The number per sickness is correct, but the total at the bottom is incorrect

  • barritown's avatar
    barritown
    Icon for Solution Sage rankSolution Sage
    2 years ago

    Don't you have some filter applied there or something else in the model I should be aware of? 

    Any chance you can reproduce this problem with some mocking data and share PBIX?

     

    P. S. It seems like your Total is showing the maximum value.

    • DummyBIDev's avatar
      DummyBIDev
      Frequent Visitor
      2 years ago

      No filters applied on the table.

      Just to be safe i created a whole new workbook and tried the filters but still the same issue

      I've created a pbix file with dummy data which i'm hoping helps

      Thanks

       

      https://www.transfernow.net/dl/20231107VnVrATAN