Forum Discussion

Casey_Alderson's avatar
Casey_Alderson
Helper I
2 years ago
Solved

Null Error - Export via Power Automate w/ Filters using Query against a data set; Curbal.com process

Hi All,    I'm using Curbal.com's process for exporting data from a report via power automate button and run a query against a dataset while using select operators to pull through filters. The repo...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    If any of the fields handed over from the Power BI integration are blank then you need to drop the related filtertable from the DAX.

     

    Note that you shouldn't use CALCULATE(SUMMARIZE() - use SUMMARIZECOLUMNS instead.  Also don't use the ORDER BY unless you really really need to.

lbendlin's avatar
lbendlin
Super User
2 years ago

If any of the fields handed over from the Power BI integration are blank then you need to drop the related filtertable from the DAX.

 

Note that you shouldn't use CALCULATE(SUMMARIZE() - use SUMMARIZECOLUMNS instead.  Also don't use the ORDER BY unless you really really need to.

  • Casey_Alderson's avatar
    Casey_Alderson
    Helper I
    2 years ago

    Hi lbendlin, 

     

    Can you explain how you would rewrite the DAX using SUMMARIZECOLUMNS? I've only gotten this far by copying what others have done via YouTube. I need all of the filters to stay dynamic and the way she accomplished that is through the combo of TREATAS and KEEPFILTER within the larger CALCULATETABLE function.