Forum Discussion
Helper IIDAX Measure won't return a proper result
Helper IIPaulDBrown 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!
Super UserI 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.
- KNP
The sample data doesn't find the solution. It gives us data to work with to find the solution so we don't have to create it manually.
Maybe start with a screenshot of your complete data model and the relationships.
You've got a lot of cross filtering going on, we need to see the entire picture.