Forum Discussion
Using measure for axis in a column graph
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! It worked but " MAX('Table'[Stages])" works as its a sample data and it has the stages as "Stage 1, stage 2, stage 3 etc but in the real senirio the stages look like, FPFV, PA, OLS, DBL etc. Which is why I added the order column using the "Table".
And for this the relationship was estabished:
I guess I can't depend on MAX('Table'[Stages] or 'Projects (2)'[Stages]. rather it has to depend on the max of "order" columns.
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!