power automate
3 Topics
Help Removing TOPN
Hello, I am using the following query from performance analyzer to use in a Power Automated flow. Can anyone help re-write this dax so that it does not include TOPN? // DAX Query DEFINE VAR __DS0FilterTable = TREATAS({TRUE}, 'Trainee Skill Completions (History)'[Skill Is Active]) VAR __DS0FilterTable2 = TREATAS({TRUE}, 'Trainee Skill Completions (History)'[Assignement Active (hide)]) VAR __DS0FilterTable3 = TREATAS({"TES"}, 'Users (Trainees)'[Division]) VAR __DS0Core = SUMMARIZECOLUMNS( 'Users (Trainees)'[Division], 'Users (Trainees)'[Office], 'Users (Trainees)'[Department], 'Users (Trainees)'[User ID], 'Users (Trainees)'[User Display Name], 'Skills'[Skill Product Line (BU)], 'Skills'[Skill Platform / Group], 'Skills'[Skill Subgroup], 'Skills'[Skill Category], 'Skills'[Skill Title], 'Skills'[Skill ID], 'FY Baseline (hide)'[Baseline Completion Rate], 'Trainee Skill Assignments'[Current Skill Completion Rate], 'Trainee Skill Assignments'[FY Target Percent], 'Trainee Skill Assignments'[FY Goal Status], 'Trainee Skill Assignments'[FY Target Goal Group], 'Trainee Skill Assignments'[Baseline Tasks Required to Goal], 'Trainee Skill Assignments'[Remaining Tasks Required to Certify], 'Trainee Skill Assignments'[Skill Level After Goal], __DS0FilterTable, __DS0FilterTable2, __DS0FilterTable3, "Number_of_Requested_Tasks", 'Task Measures'[Number of Requested Tasks], "Remaining_Mandatory_Tasks", 'Task Measures'[Remaining Mandatory Tasks] ) VAR __DS0PrimaryWindowed = TOPN( 501, __DS0Core, 'Skills'[Skill Product Line (BU)], 1, 'Users (Trainees)'[Division], 1, 'Users (Trainees)'[Office], 1, 'Users (Trainees)'[Department], 1, 'Users (Trainees)'[User ID], 1, 'Users (Trainees)'[User Display Name], 1, 'Skills'[Skill Platform / Group], 1, 'Skills'[Skill Subgroup], 1, 'Skills'[Skill Category], 1, 'Skills'[Skill Title], 1, 'Skills'[Skill ID], 1, 'FY Baseline (hide)'[Baseline Completion Rate], 1, 'Trainee Skill Assignments'[Current Skill Completion Rate], 1, 'Trainee Skill Assignments'[FY Target Percent], 1, 'Trainee Skill Assignments'[FY Goal Status], 1, 'Trainee Skill Assignments'[FY Target Goal Group], 1, 'Trainee Skill Assignments'[Baseline Tasks Required to Goal], 1, 'Trainee Skill Assignments'[Remaining Tasks Required to Certify], 1, 'Trainee Skill Assignments'[Skill Level After Goal], 1 ) EVALUATE __DS0PrimaryWindowedSolved1.4KViews0likes3Comments
Text filter
Hi everyone! sorry if my question is a dumb one.... I am almost sure what I am asking is impossible. 🙂 I have a requirement where I would like to store all the searches in a TEXT FILTER visualization that have no results. The idea is for a KNOWLEDGE BASE and I would like to understand what are the users searching with no results so I can create that new content. Is it possible to somehow use the string used in TEXT FILTER in a measure or something in order to trigger somehow a flow with Power Automate?499Views0likes1CommentA question about using the action run a query against a dataset
Hello, I don't know if my question goes here or in Power Automate's forum because I have a dataset with user data from an app that I am trying to leverage in Power Automate using the action "run a query against a dataset" where DAX can be used to bring data from the dataset. The dataset has a column "number of hours" and a measure "Total number of hours", which I am trying to filter by status ("Completed", "Under Review", "not submitted") and by each user using said action from Power Automate. What I am trying to accomplish is to get a JSON using the query where I get the name of each user and their total hours filtered by "not submitted" and by the other two statuses. My first question is: Can it be done? If my first question is positive, can someone give me some pointers on how can I accomplish that? Thanks for your help.Solved6.6KViews0likes3Comments