Forum Discussion

MrAtkinson's avatar
MrAtkinson
Frequent Visitor
2 years ago

Dax code from power bi performance analyzer doesn't work when put into power automate flow.

Hi all,   I am trying to have power automate export a particular matrix table and and save it into sharepoint. I have created the flow but the code i am pasting for the matrix i need exporting does...
Need Help
lbendlin's avatar
lbendlin
Super User
2 years ago

When you borrow DAX code from Power BI visuals you don't want to have totals. Disable them and you will see the code becomes much simpler.

// DAX Query
EVALUATE
  VAR __DS0FilterTable = 
    TREATAS(
      {"Armadillo",
        "Director",
        "Essentials",
        "Kickstart",
        "Plus",
        "Standard",
        "Umbrella"},
      'si_membership'[Grade]
    )

 

  VAR __DS0FilterTable2 = 
    TREATAS({"Valid",
      "Pending Cancelled"}, 'si_membership'[Subscription Status])

 

RETURN SUMMARIZECOLUMNS(
      'Calendar PQ'[Week number (month)],
      'si_membership'[Grade],
      __DS0FilterTable,
      __DS0FilterTable2,
      "Count_of_Subscription", [Count of Subscription]
    )