Hello all,
Need some help on this
In my excel table (call CallTABLE), I have a column with header named Site with the following four cities: Portland, Washington, Houston, Pittsburgh)
I have another column with header named "Result", and within the column it will have either Met, Not Met, or Not Evaluate.
I have my pivot table setup as data-model type pivot table as I need it for other items.
Is there a DAX formula which count how many times Met, Not Met, and Not Evaluate appears for each Site?
Thanks in advance.
Bookmarks