Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I am looking for some help to understand how to do what I think is a 3 step process using measures.
This is an example of 1 record in the date source
Date Source | ||||
ID | Positive Marks | Negative Marks 1 | Negative Marks 2 | Negative Marks 3 |
1 | 1 | 0 | 0 | 0 |
1 | 1 | 0 | 0 | 0 |
1 | 0 | 1 | 0 | 0 |
1 | 1 | 0 | 0 | 0 |
1 | 1 | 0 | 0 | 0 |
1 | 0 | 0 | 1 | 0 |
1 | 0 | 0 | 1 | 0 |
1 | 1 | 0 | 0 | 0 |
1 | 0 | 1 | 0 | 0 |
1 | 0 | 0 | 0 | 1 |
1 | 0 | 0 | 0 | 1 |
This is what I am looking at summarising from the date source then use to create the finall output
Summarised | ||||||
ID | Positive Marks | Negative Marks 1 | Negative Marks 2 | Negative Marks 3 | Total Marks | % of Positive Marks |
1 | 5 | 2 | 2 | 2 | 11 | 45.5% |
Count all records that are above a particular %
Count the number of % that are greater than 40% | ||||
Count | ||||
Finall Output | 1 |
Many thanks
Solved! Go to Solution.
Yes, sort of. You can go easier on the filter, using TREATAS and DATESBETWEEN instead.
Thanks for the support.
Does this look right, I am having trouble getting the dates to filter the SUM
- Table Test =
SUMMARIZECOLUMNS
('Attendance (Table)'[Primary Key],
FILTER(('Attendance (Table)'),
AND('Attendance (Table)'[Mark date]>=MIN('Academic Year (Table)'[End of week]),
'Attendance (Table)'[Mark date]<=MAX('Academic Year (Table)'[End of week]))),
"Present",SUM('Attendance (Table)'[Present]),
"Authorised", SUM('Attendance (Table)'[Authorised Absence]),
"UnAuthorised", SUM('Attendance (Table)'[UnAuthorised]),
"Study", SUM('Attendance (Table)'[UnAuthorised]),
"AEA", SUM('Attendance (Table)'[AEA])
)
Yes, sort of. You can go easier on the filter, using TREATAS and DATESBETWEEN instead.
I ended up here to produce a table.
But if I try to add another column to flag who is below 90% it gives a circular reference.
Any help appreciated
You cannot measure a measure. Each measure needs to implement its own business logic.
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
99 | |
93 | |
88 | |
70 |
User | Count |
---|---|
166 | |
133 | |
129 | |
102 | |
98 |