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!