Forum Discussion

taylorrc's avatar
taylorrc
Regular Visitor
9 years ago
Solved

Use Measure as Axis in visual

I am trying to create a visual similar to this:   but I need to include some values that are sumations of some of the columns. For example, a total column that is a sum of all the values. Ano...
Need Help
  • taylorrc's avatar
    taylorrc
    9 years ago

    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]))
taylorrc's avatar
taylorrc
Regular Visitor
9 years ago

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]))

 This retuned the values that I needed for the visualtion. Its a little brute force, but it worked. 

goldfred's avatar
goldfred
Regular Visitor
8 years ago

Hi taylorrc, it seems a great solution !

 

But I don't understand how you inplement your "IF statements" to look at your table with x labels

and return the correct measure : subtotal or the value.

 

Could show me the differents steps you implemented ?

 

Thank you and have a nice day !

Fred