topic How to achieve Don't Summarize as a measure in DAX Commands and Tips

How to achieve Don't Summarize as a measure

Anonymous — Wed, 09 Feb 2022 16:25:08 GMT

I have a decimal number column called Response see in the table last column.
I want to create a measure which do not summarize the values as I need to reuse this measure in another dax .

So how can we acchieve the same output that does not sum up the values in DAX

Re: How to achieve Don't Summarize as a measure

ValtteriN — Wed, 09 Feb 2022 16:41:49 GMT

Hi,

What is the reason you need this functionality/What is your end goal? This isn't really possible with measures since it isn't needed. E.g. if you want to calculate DAX in a row context on a table you can use functions like SUMX or AVERAGEX.

Re: How to achieve Don't Summarize as a measure

Anonymous — Wed, 09 Feb 2022 17:01:34 GMT

OK got it, just asking if it was possible

Re: How to achieve Don't Summarize as a measure

shalu097 — Thu, 07 Mar 2024 09:51:36 GMT

Hey, but I need this as sumx or averagex is not giving right data.

Here i dont want to summarize "year old" value, i want to do calculation row wise in table.

How can i do that?