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.
I currently have an excel report that has multiple countifs for each data integrity check. What would be the best way to recreate this in BI? How would I recreate the countifs ? Measures for each 'Integrity Check'? Sample file attached.
Result of check #1 = 2 jobs meet criteria
Solved! Go to Solution.
@Anonymous
The above formula that i wrote is a measure not a column.
So create a new measure and add the formula
@Anonymous
See a countif formula below:
COUNTIFS =
CALCULATE (
COUNT( Table[ID]),
FILTER (
Table,
Table[Dim1] = "Value_1"
&& Table[Dim2] = "Value_2"
&& Table[Dim3] = "Value_3"
)
)
@themistoklis Can this be done using a measure/calc? Still fairly new to BI and still learning.
@Anonymous
The above formula that i wrote is a measure not a column.
So create a new measure and add the formula
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.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |