Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am trying to make a report in PowerBI that shows the status of files in a list. The rows in the dataset are being pushed into the table from a connector in Flow. So I want to show a file as Pending only if it hasn't later been Approved or Rejected.
Each file has a uniqie ID. My idea was to filter the Pending row if there is an exact match in the FileID column. In a PowerBI report, how can I only display the row that says Pending when there is not a duplicate number in FileID for Approve or Reject?
In the example below, I only want to show the Approve row for upload-demo.docx, the Reject row for test-send.xlsx, and the Pending row for export.site.txt. Please help!
FileID | Filename | Status |
5MFIYUS2 | upload_demo.docx | Approve |
5MFIYUS2 | upload_demo.docx | Pending |
M3R33DJL | test-send.xlsx | Pending |
M3R33DJL | test-send.xlsx | Reject |
CYFH25YP | export-site.txt | Pending |
You are going to need a flag column or measure along the lines of:
Flag Column =
VAR __Statuses = SELECTCOLUMNS(FILTER('Table',[FileID] = EARLIER([FileID]),[Status])
RETURN
SWITCH(TRUE(),
[Status] = "Approvied" || [Status] = "Rejected",1,
NOT("Approved" IN __Statuses) && NOT("Rejected" IN __Statuses),1,
0
)
Thank you for the code. Since this is a report coming from a streaming dataset, won't I be limited to just the one table 'RealTimeData'? PowerBI won't allow the table Statuses in the report with the table made from the streaming dataset. Apologies for the noob questions.
Anne
User | Count |
---|---|
99 | |
86 | |
78 | |
75 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |