Problems to do a rowcount

[Rigolleto]

Hi,

I need  a way to get the max value of the column COLOR, for instance, I need to show in a grid the values as 1/4, 2/4, 3/4 and 4/4, I did create a measure but something is wrong, notice that even I did add a max it alway showing a result as 1/1, 2/2,3/3 and 4/4 instance of 1/4, 2/4, 3/4 and 4/4, I have a filter by the couln sty, this has for instance sty 100 and have 4 colors asigned, can someone tell me the best way to get the max and use it as a contant in my denominaor?

Thanks

[Anonymous · Accepted solution]

Hi @Rigolleto ,

I created three DAX columns :

1. This beloe DAX to give me the MAX from the color

MAX_By_category = CALCULATE(MAX(Table7[COLOR]),FILTER(Table7,[STY]=EARLIER(Table7[STY])))

2.  This below DAX column to concatenate the value with "/"

Concatenate Color with / = CONCATENATE(Table7[COLOR],"/" )

3. This below DAX to contacenate the first two above columns

Column 4 = CONCATENATE(Table7[Concatenate Color with /],Table7[MAX_By_category])

My output:

Let me know if this works.

Thanks,

Tejaswi