I'm having an issue with some pretty simple DAX that did work, then stopped.
I have an Orders table, and I wanted to use a simple Power Apps form to allow people to add comments to a linked Dataverse Table via the Power BI report. It works like this:
- I am passing a measure that is SELECTEDVALUE('Order Details'[Order/Item Key]) to the Power App.
- The user selects their order from a table visual to the left of the form.
- I had the Power App determine if a record exists in the dataverse table for that order/item key, and either go to edit or new mode.
This was tested and working, however last week it stopped working for records that do have an entry in the dataverse table.
The Power BI table visual does include columns from both the orders table and the dataverse table, with show blanks allowing users to see which records have comments, and which don't. Now when a user selected a record with no dataverse entry, the Selected value metric always returns blank, so I can't pass the record to the form.
I've tried remove filters on the dataverse table, but nothing seems to be working. Has anyone run into this.
