Forum Discussion
Passing Measure output in MQuery
- Anonymous1 year ago
v-dineshya Thanks for checking. We have done it in other way. I will share it once it is done.
Right now it is required we can close this.
Hi, A PowerBI User can never return a input field / parameter from a PowerBI report back to the data load / Power Query M steps. What I would suggest if possible to remove the HAVING SUM([CustomsValue]) > 500 code in your sql statement. So you load all records. When it's all loaded you can write a measure to only show records in a table visual that have a customervalue above x. And X you can return out of the slicer value the user selected.
- Anonymous1 year agoNot applicable
Thanks! Sorry for late response. I am back today as there was family emergency. Will check and update in couple of days.
- v-dineshya1 year agoCommunity Support
Hi Anonymous ,
I was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.
Regards,
Dinesh
- Anonymous1 year agoNot applicable
v-dineshya Thanks for checking. We have done it in other way. I will share it once it is done.
Right now it is required we can close this.