topic Re: DAX measures on axes question in DAX Commands and Tips

DAX measures on axes question

TWijnen — Thu, 26 Jan 2023 16:22:07 GMT

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.

Re: DAX measures on axes question

wdx223_Daniel — Fri, 27 Jan 2023 07:38:41 GMT

you need add a calculated column in your source data

Re: DAX measures on axes question

TWijnen — Sat, 28 Jan 2023 06:15:21 GMT

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?

Re: DAX measures on axes question

v-zhangti — Mon, 30 Jan 2023 07:22:53 GMT

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.

Re: DAX measures on axes question

TWijnen — Wed, 01 Feb 2023 07:05:48 GMT

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.