Hello pro-users, how will this work in PBI &/or Automate (as example code if available)?
1. Update = Get FullTable into pbi on Button-Click (4 FilterCols + 1ResultCol, done with automate update cloud flow)
2. pbi-user-interact = user sets 4 FilterCols (in pbi (?or better power apps?) user sets filters) = this is current end (to extend)
(each of 4 FilterCols are drawn as 4 separate DistinctRowTables, yet it seems to be an avoidable double effort)
3. ResultTable = ?Calculate(FullTable, Filter(FilterCol1=f1:UserFilter1 & FilterCol2=f2 & FilterCol3=f3 & FilterCol4=f4))?
Question: ? = I. How to return a ResultTable , II. Which SYNTAX to correctly reference to pbi-user-set filters (how to get them)?
4. button/flow = Use ResultTable in next Query => Question: Automate button again anf if new one, or same as above?
Seems to be a standard operation procedure, Kind regards for any indication / links
