Rookie data modelling issues

HI Anonymous,

#1, So you mean you want to have a visual with configurable visual axes based on user operation/selection?

If that is the case, I'd like to suggest you create two calculated tables with all requirement types and use them on axis and legend. For the value part, you can write a measure expression to look up and calculate the value from the raw table based on current axis values.

Using the SELECTEDVALUE function in DAX 

#2, Your data structure seems not able to direct achieve the graph on radar visual. I'd like to suggest you use the 'requirement' field on category and write measure expressions to calculate different tool types and use on y-axis field.

Sample:

Spoon =
CALCULATE (
    SUM ( 'Table'[Value] ),
    FILTER ( ALLSELECTED ( 'Table' ), [Tool] = "Spoon" ),
    VALUES ( 'Table'[Requirements] )
)

Regards,

Xiaoxin Sheng