Forum Discussion

AndreiK15's avatar
AndreiK15
Icon for Helper II rankHelper II
4 years ago

DAX Measure won't return a proper result

Hi,   I'm struggle with this easy measure and I can't figure it out what's wrong. I've tried all filters combinations and still get the same result as soon as I add hours intervals. See pictures be...
Need Help
PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
4 years ago

can't you replicate the tables with sample data in Excel and post them?

  • AndreiK15's avatar
    AndreiK15
    Icon for Helper II rankHelper II
    4 years ago

    PaulDBrownwould that be ok? That's exactly what I need to achieve.

     

     

    Thanks!

     

    • PaulDBrown's avatar
      PaulDBrown
      Icon for Community Champion rankCommunity Champion
      4 years ago

      We need actual raw data! 

      • AndreiK15's avatar
        AndreiK15
        Icon for Helper II rankHelper II
        4 years ago

        PaulDBrown  thank you for your help and don't try to be rude, but giving you a raw data set won't fix the problem and won't provide me a solution. I will wait for a MS expert to try to solve it. The issue is not from the data. The issue is with the filters and relationships between tables.

         

        If you need a raw data set, use randbetween on Excel and generate some data set. Create some categories on the left and timeframes on top and you have a data set, but won't provide a solution.

         

        Thanks again!