radar (spider) chart with two measures from same data source

[AndrewPF]

I am using the SpiderChart by visiochart to show scores across different security factors for two different companies. 

However, these scores are currently hard coded and I want the chart to show scores based on user input as follows: 

where I have measures of "score 1" and "score 2" based on slicers "company 1" and "company 2". 

Is this possible? 

[AndrewPF]

Thank you, that's exactly what I needed. 

[AndrewPF]

Hi, 

the structure of the data is as follows: 

company	factor	score
Company A	cubit	28.43
Company A	patching	19.91
Company A	app_security	62.38
Company A	dns	77.68
Company A	network	45.36
Company A	social_eng	88.14
Company A	leaked_info	98.09
Company A	ip_rep	50.84
Company A	hacker	38.09
Company A	endpoint	21.06
Conglomerate B	cubit	97.86
Conglomerate B	patching	80.66
Conglomerate B	app_security	23.45
Conglomerate B	dns	15.25
Conglomerate B	network	58.67
Conglomerate B	social_eng	7.83
Conglomerate B	leaked_info	17.57
Conglomerate B	ip_rep	46.16
Conglomerate B	hacker	9.3
Conglomerate B	endpoint	81.35
Consortium C	cubit	79.36
Consortium C	patching	10.43
Consortium C	app_security	29.81
Consortium C	dns	65.31
Consortium C	network	26.07
Consortium C	social_eng	50.67
Consortium C	leaked_info	81.28
Consortium C	ip_rep	57.27
Consortium C	hacker	37.2
Consortium C	endpoint	33.2

and my two measures are: 

score 1 = calculate(sum('Factors'[score]), 'Factors'[company] = "Company A")

and

score 2 = calculate(sum('Factors'[score]), 'Factors'[company] = "Conglomerate B")

but I want to create score 1 and score 2 based on slicers for end-user input instead of hard coding them.

[v-yanjiang-msft · Accepted solution]

Hi @AndrewPF ,

If you mean select two values in the company slicer, score1 for the first and score2 for the second, modify the formula to:

score 1 =
CALCULATE (
    SUM ( 'Factors'[score] ),
    'Factors'[company]
        = MINX ( ALLSELECTED ( Factors[company] ), 'Factors'[company] )
)

score 2 =
CALCULATE (
    SUM ( 'Factors'[score] ),
    'Factors'[company]
        = MAXX ( ALLSELECTED ( Factors[company] ), 'Factors'[company] )
)

Get the same result with the hard coding formula:

I attach my sample below for your reference.

Best regards,

Community Support Team_yanjiang

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

[v-yanjiang-msft]

Hi @AndrewPF ,

I'm not quite clear what's the data structure your modle is. I create a sample:

But seems it's not quite the same with yours. Please clarify more details.

Best regards,

Community Support Team_yanjinag