Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Team,
I have a software which is used to investigate and record the root cause of errors made in the process or system at my company. There is a ML model developed to assist the investigator to find root cause in a quick time.
The model output is shown in a Power BI dashboard. it is neccassary to view the dashboard on the same day he is doing the entries in software. now to monitor the adherence of the dashboard, i want to create another report where in i just want to make sure that the person doing the entries in software is refereing to the Model output dashboard or not.
So here i am comparing 02 dates from 02 different tables, i.e. ML Model output table and the inbuilt Usage metrics report table.
if i compare both dates from both tables, then the problem i am facing is that the inbuilt Usage Metrics report table is refreshed on next day, hence i am not able to get accurate and exact results from the comparison.
i have created 02 measures for this:
Hi @lbendlin
Please find below sample data and expected output:
Table 1
Error ID | Location | Date of Initiation |
11 | A1 | 01.10.2022 |
22 | A2 | 30.08.2022 |
33 | A3 | 26.08.2022 |
44 | A2 | 25.08.2022 |
55 | A3 | 23.08.2022 |
66 | A1 | 20.08.2022 |
77 | A4 | 15.08.2022 |
88 | A5 | 19.08.2022 |
99 | A1 | 20.08.2022 |
Table 2:
Dashboard report View | Location | Date of View |
2 | A1 | 02.10.2022 |
3 | A2 | 01.10.2022 |
1 | A3 | 27.08.2022 |
4 | A2 | 26.08.2022 |
2 | A3 | 24.08.2022 |
3 | A1 | 21.08.2022 |
1 | A4 | 20.08.2022 |
3 | A5 | 14.08.2022 |
2 | A1 | 22.08.2022 |
Expected result:
Location | % Adherence | Remarks for understanding purpose only |
A1 | 1 | next day view, hence should return 1 as a match |
A2 | 1 | next day view, hence should return 1 as a match |
A3 | 1 | next day view, hence should return 1 as a match |
A4 | 0 | 05 days gap in view, hence should return 0 as a match |
A5 | 0 | No match in date, hence should return 0 |
A1 | 0 | 02 days gap in view hence should return 0 |
Please let me know if this makes sense for you.
Regards
Satish
How do you correlate the dashboard view event to the error ID? From our sample data it is not clear how a dashboard view event should be attributed to the error instance.
i am comparing both tables based on the Location column.
That is not good enough, it leads to ambiguity, especially for A1.
Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.