Forum Discussion

Rigolleto's avatar
Rigolleto
Resolver I
7 years ago
Solved

Problems to do a rowcount

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 ...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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