topic Measure giving count of items within a field in DAX Commands and Tips

Measure giving count of items within a field

Anonymous — Mon, 20 Jun 2022 14:41:39 GMT

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 — Mon, 20 Jun 2022 14:48:48 GMT

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 — Mon, 20 Jun 2022 14:58:06 GMT

That worked perfectly, thank you so much!