Forum Discussion
Use Measure as Axis in visual
I solved the issue. I created a new table with the axis lables in the first column, then used If statements to look at the value in the first column. If it was one of the subtotals, it returned the measure I created. If it was an actual status, I used:
CALCULATE(counta('Idea Factory One Utility'[Status Of Idea]),
FILTER(all('Idea Factory One Utility'), 'Idea Factory One Utility'[Status Of Idea]=Idea_Status[Status Type]))
Hi, I assume that you have a whole table of data that has all the projects on it with some sort of mixture of flags that in an order give you whatever the status is. What you will want to do is make a calculated column (on the modelling tab) and make a column that has all the logic in it to create each of teh the statuses you want on your axis. This is just an IF() statement or if you want a SWTICH(). SO you will have something like:
Status = IF(OR(Table[status] = "accepted",Table[status] = "just about accepted"),"Accepted" ...etc.... )))
Satus = SWITCH(Table[status], "accepted","Accepted","just about accepted","Accepted" ....etc... )))
You then use the status column as the x axis. You should need any other measures that a count of projects..
// If this is an answer to your question please mark as such
Hi - I also am unclear how to use the if or swtich statements particularly if we are creating the new 'dummy' table to just hold the axis lables and it does not have any relationship with the fact or table that holds the measures.
I have to categories that I want on the axis Direct and Sub and I have 4 measures total where 2 need to show in the Sub category and 2 others need to show in the Direct category. i've just one measure calculation for each category below.
To show in Direct category:
To show in Sub category:
The attempted SWITCH statement, I could not get SWITCH to accept just the dummy 'axis' column I created as the first argument