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
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!

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

I have access to a number of sample data sources, but unless you help me understand what you are trying to calculate, and the reason for the crossfilters for tables not shown in your depiction of the model, and the expected output, it is not possible to provide help. 
I'll leave it to a an MS expert.

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

    PaulDBrown  db I'm connected to have few hundreds of tables and probably billions of row. Hours interval is on POS Hours tables and concted to POS Sales tables as a one-to-many relationship.

    Sales is linked like this:

     

    and POS Sales is linked like this:

     

     

    I believe this would be much helpful than provide a data sample.