DAX measures on axes question

[TWijnen]

Hi, can someone please help with the following case?

I would like to use measures on axes, or maybe there is another way. See attached image.

[TWijnen]

Hi @v-zhangti 

Thanks for your reply. I still need to try it out on my dataset, the example I gave is very simplified compared to my real world scenario.

I see you used calculated columns, that is really helpful to me, for some reason I was thinking I could only solve this using measures.

I will reply later with my findings.

I dont understand why this post/question was marked as solved when I have not replied yet.

[v-zhangti · Accepted solution]

Hi, @TWijnen 

You can try the following methods.
Column:

Sum input = CALCULATE(SUM('Table'[input]),ALLEXCEPT('Table','Table'[day]))

Sum onput = CALCULATE(SUM('Table'[output]),ALLEXCEPT('Table','Table'[day]))

Category = SWITCH(TRUE(),
[Sum input]>[Sum onput],"more input",
[Sum input]<[Sum onput],"more onput",
[Sum input]=[Sum onput],"equal")

Count days = CALCULATE(DISTINCTCOUNT('Table'[day]),ALLEXCEPT('Table','Table'[Category]))

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[TWijnen]

You mean for the logic in the "category measure"? I don't think that will work because at raw data row level there will be different outcomes of the "category measure" vs the outcomes on agreggated level. Check the data.

Agree? Or did you mean something else?

[wdx223_Daniel]

you need add a calculated column in your source data