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
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

AndreiK15 , what are you trying to achieve here ?

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

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

    amitchandakI am trying to get Sales Qty per hour intervals for each category on the left and their totals. I can't share a sample as I'm connected to SASS and a sample won't make a difference. I've made a screenshot with a matrix and relationships between pos sales (from where I get sales qty) and pos hours from where I get hours intervals. Also, the main measure I use to get sales qty (which can be changed if necessary).

     

    Thanks!