COUNTIFS for a column based on a measure and another column

[EricC62]

I need to replicate the data shown below in an Excel snippet over in a table in Powerw BI (PBI).

My PBI table has multiple columns, two of which are "Term" and "FACID"; in addition, I have created a measure in PBI titled "LatestTerm".

I want to create a new column in my PBI table titled TimesInLatestTerm that counts the number of times each FACID occurs when the Term = LatestTerm. I want this value returned for all occurences of FACID regardless of if the adjacent term is or isnt equal to LatestTerm.

I have experimented with formulas in a number of the posts with "COUNTIFS", but none of them produces the counts I am looking for as seen in the Excel output.

[lbendlin · Accepted solution]

You cannot measure a measure directly. Either materialize it first, or create a separate measure that implements the entire business logic.
You cannot (meaningfully) create a calculated column or calculated table from a measure.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...