topic Re: Count Text content in measure in DAX Commands and Tips

Count Text content in measure

George1973 — Fri, 02 Oct 2020 09:39:39 GMT

Hi All,

Please assist in the following issue.

I have the following visual matrix:

Num	Avg.Score	Max Score Single task	% Total Score	VOC LVL
199	12	12	100.00%	Good
200	11	12	91.67%	Good
201	9	12	75.00%	Medium
202	11	12	91.67%	Good
203	12	12	100.00%	Good
204	12	12	100.00%	Good
205	7	12	58.33%	Bad
206	9	12	75.00%	Medium
207	12	12	100.00%	Good
208	10	12	83.33%	Medium
209	12	12	100.00%	Good
210	12	12	100.00%	Good

And Only the first column is column from the Data Table. All other columns are measures.

I want to create a measure to count "VOC LVL" values - Intending to know how many "Good", "Medium" and "Bad" records we have.

The problem I have is that VOC LVL is also a measure and I can not count its content because it's not a column context.

VOC LVL = SWITCH(TRUE(),[Avg.Score]>=11,"Good",[Avg.Score]>=8 && [Avg.Score]<=10,"Medium",[Avg.Score]<=7,"Bad")

Hope there is a solution. Your help will be highly appriciated.

Thanks in advance,

Re: Count Text content in measure

amitchandak — Fri, 02 Oct 2020 10:02:55 GMT

George1973 , For that you have to bucket/dynamic segmentation. You need an independent table and create new measure using those

Have look at my video and file. if those can help: https://youtu.be/CuczXPj0N-k

File attached after signature

Re: Count Text content in measure

George1973 — Fri, 02 Oct 2020 10:48:19 GMT

amitchandak Thanks a lot!

It's was really helpful. I was also thinking about the indipended table and bins, but the measure you've provided in your video was a real breakthrough 🙂

Thanks.

Re: Count Text content in measure

George1973 — Fri, 02 Oct 2020 13:27:41 GMT

amitchandak Here is the final VOC dashboard. With your help the almost 40% of the work was done in very sufficient way.
Thanks a lot once again.

P.S. Do not get confused with the Georgian writings 🙂