Forum Discussion

George1973's avatar
George1973
Icon for Helper V rankHelper V
5 years ago
Solved

Count Text content in measure

Hi All,

Please assist in the following issue.

I have the following visual matrix:

NumAvg.ScoreMax Score Single task% Total ScoreVOC LVL
1991212100.00%Good
200111291.67%Good
20191275.00%Medium
202111291.67%Good
2031212100.00%Good
2041212100.00%Good
20571258.33%Bad
20691275.00%Medium
2071212100.00%Good
208101283.33%Medium
2091212100.00%Good
2101212100.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,

 

 

Help with DAX Measure

3 Replies

    • George1973's avatar
      George1973
      Icon for Helper V rankHelper V
      5 years ago

      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.

      • George1973's avatar
        George1973
        Icon for Helper V rankHelper V
        5 years ago

        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 🙂