Can anyone here help me out in finding the DAX function to count specific text values from a column? The column contains multiple values. I tried using the COUNTA function but it totals every blank field. I hope someone could help me on this.

Can I ask a follow-up question? In situations where you have multiple values in the column, do you create a measure for each one? Would you approach it the same if there as a 4 text values or 104 text values?

For instance, I am looking at data over a 5 year period. I have four values that I want to look at to determine how many employees are eligible for retirement under four conditions: EARLY, OPTNL, READY IM, and INEL. I want to be able to compare how many employees fit each condition now, a year from now, and three years from now.

Thanks for that. I donâ€™t have 104 values. I was trying to better understand the thought process around problems like this. For instance, there may be a way that works for 4 values, while not so efficient for 104 values. I want to be sure that I am thinking about these things correctly.

Thank you! I knew that I needed to make a connection, but I wasnâ€™t sure of how to do that. Thank you for recommending that course. I was trying to figure out what course I needed next. Searching for â€śmodelingâ€ť gives me too many options as a novice.

Iâ€™m curious about something. None of the connections were active. If I am understanding the DAX formula, the USERELATIONSHIP function creates the connection. I donâ€™t get why. Will the course help unpack this? If not, do you mind recommending a video/course?

Two things to think about before trying to get a better understanding of DAXâ€¦

You need a datamodel before you can write any DAX at all

No (or only huge) amounts of DAX compensate for a poorly designed datamodel

Therefore I always suggest to start with Advanced Data Transformations & Modeling as soon as possible. Getting your head around that quickly will save you a lot of time in the end.

It wonâ€™t be a wild guess to assume you have an extensive Excel background, right? Then start by forgetting all you know and all you think you know because DAX expressions might have the same name but operate differently then you are used to in Excel. Just think about it, you can only reference Tables and Table[Columns] in DAX expressions, not individual cells.

What Power BI and Excel do have in common however is that there are always many different ways to solve a problem or calculate a result. This was already beautifully illustrated by @AntrikshSharma who provided you several options to calculate the same thing BUT the end result will always depend on your datamodelâ€¦

When youâ€™ve finished the Modeling course I would suggest to move on to

There is also an aid available, called the Learning Map to help you navigate through the extensive learning content provided by eDNA.

And although it can be daunting and intimidating at first, the fast track to mastering Power BI is participating in the eDNA Challenges. There is so much idea-, technique-, knowledge sharing, collaboration, encouragement and feedback going on - you will pick up something valuable every time, I guarantee. And that will benefit you in your learning and day to day tasks.