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 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

 

 

 

 

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

1 Reply

  • 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