Forum Discussion
CountIFs for Data Integrity Report
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 'In...
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