Capturing a SELECTEDVALUE measure in a matrix without iterating through all data

[Anonymous]

Hi all, I have an interesting question here regarding measure behavior. I have a matrix of data (parent sites with child sites), which works fine (redacted below).

This data gets exported to Power Automate via a button, where it's turned into an array, etc.

As part of this export, I need to capture the selected Year and Quarter from our date table. Those need to be measures, of course. However, adding a SELECTEDVALUE(Year) and SELECTEDVALUE(Quarter) to the table results in the following, where every parent is now associated with every child.

I believe this is expected measure behavior. I could filter out the blanks via a visual-level filter, which would solve the display issue. However, the raw underlying data (including all the blanks, etc.) is captured in the Power Automate export, which causes data volume issues and dropped records.

Is there a way to prevent this?

[lbendlin · Accepted solution]

Adding these measures to the table visual is not relevant. The Power Automate visual has its own filter context. In that filter context SELECTEDVALUE(Year) may be meaningless or blank.

[Anonymous]

Hi @lbendlin - correct, the question was because adding filters to the Power Automate visual didn't seem to be working, but I tried again and it went through this time. Didn't change anything, but it's working now. Marking this as accepted in case others have the same question