Forum Discussion

sambgv's avatar
sambgv
Helper I
2 years ago

DAX Formula, Filtering Complications

Hello, community!  So I have a formula that should compute the total hours for work efforts in an organisation. These efforts are booked in certain accounts, and in these accounts there are certai...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi sambgv ,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

  • sambgv's avatar
    sambgv
    Helper I
    2 years ago

    hi Anonymous some_bih 

     

    I have created sample data. You can find it here 

     https://drive.google.com/drive/folders/1YUwcu8rDAIs_UKgWFpBLzQwWL139okT7?usp=sharing

     

     

     

    My overall objective is the following: 

    • I need to see the correct sum of TotalTime booked per team per account in the date columns. Eventually the total sum of booked hours per team at the end of each months (summing up all accounts)
    • On the user level: the TotalTime in the date columns. 
    • Generally, what i need is the correct sums 😄 when i make use of slicers in the report