Forum Discussion
Helper IIDAX Measure won't return a proper result
Helper II
Community ChampionWe need actual raw data!
- AndreiK15
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!
- KNP
Super User
I think you're missing the point. They're trying to come up with a solution for you but to do that effectively, they're asking that you provide some sample data to work with.
Please read: https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523#M607150
- AndreiK15
KNP sorry, but how a sample data would find a solution? Maybe I do miss a point here and I apologize, but my problem is not on creating a simple measure (or maybe it's simple). With a sample data you it will work even if you use =sum(table[qty]). Anyway, if nobody can't help me on this, I would try to figure it out by myself and again, I do apologize. Didn't try to ofend anyone. Still believe a data sample with hours intervals on top and some categories on left with a bunch of random number won't fix my problem.
- PaulDBrown
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
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.
