Forum Discussion
Solved
Using measure for axis in a column graph
I want to show the current status or stage in which the project is in. If there is "stage 4" completed in the table that means the project is in stage 4, completing stage 1,2 and 3 (thought the statu...
Hi SDVN ,
No problem just change the measure to get the order value instead of the Stage value something similar to this:
Project by Status Withou Relationship = VAR _Stage = MAX('Table'[Order]) VAR _temptable = CALCULATETABLE( SUMMARIZE( 'Projects (2)', 'Projects (2)'[Projects], "Status", MAX('Projects (2)'[Order]) ), CROSSFILTER( 'Projects (2)'[Order], 'Table'[Order], None ) ) RETURN COUNTROWS(FILTER( _temptable, [Status] = _Stage ))Has you can see the result does not change:
Hi SDVN ,
No problem just change the measure to get the order value instead of the Stage value something similar to this:
Project by Status Withou Relationship = VAR _Stage = MAX('Table'[Order])
VAR _temptable = CALCULATETABLE(
SUMMARIZE(
'Projects (2)',
'Projects (2)'[Projects],
"Status", MAX('Projects (2)'[Order])
),
CROSSFILTER(
'Projects (2)'[Order],
'Table'[Order],
None
)
)
RETURN
COUNTROWS(FILTER(
_temptable,
[Status] = _Stage
))
Has you can see the result does not change:
Thank you so much for solving the problem and also I realized how much more I need to practice to get a hang of DAX!