Forum Discussion
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
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
Thank you! Measure expressions are exactly the solution I was looking for but since I am new to this tool I didn't even know they existed. Problem solved 😄