Measure giving count of items within a field

[Anonymous]

Hi all,

This might be a basic question but I'm new to Power BI (and couldn't find a related question that translated directly to my query).

I have a field (or column) that contains two items of information, X and Y. 

I need to create a measure that will give me the count of X within that column. How would I go about this?

Any help would be greatly appreciated!

Cheers

[AlB · Accepted solution]

Hi @Anonymous 

Measure =
CALCULATE(COUNT(Table1[Column]), Table1[Column] = "X")

You can also use a slicer to select "X" (or "Y") and have a more generic measure

Measure =
COUNT(Table1[Column])

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[Anonymous]

That worked perfectly, thank you so much!