Radar chart for beginner

Hi,scottda4270 

Regarding the issue you raised, my solution is as follows:

1. First I created the following table based on your description:
   

2.Next please select the view to download Radar view:

3.I then created the following measure:

Measure = CALCULATE(COUNTROWS('radartable'),FILTER(ALLSELECTED('radartable'),'radartable'[category]=MAX('radartable'[category])&&'radartable'[value]=MAX('radartable'[value])))

4.Here's my final result, which I hope meets your requirements.

Can you share sample data and sample output in tabular format if I am misunderstanding? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Anonymous @thank you so much. This is exactly what I was trying to do. I have not used Measures before so I don't understand the syntax of your solution so I may have to do some reading up.  I did manage to find a workaround but it's not as elegant as yours. I added additional columns in my dataset for each colour. I then wrote an IF statement to populate each row with a 1 or 0 based on condition. It works, but I like your solution better. Thanks again