topic Re: Summarize function in DAX Commands and Tips

Summarize function

Chandrashekar — Mon, 17 Jan 2022 06:16:27 GMT

Hello Team,

How to add summarize function to below measures as am using this in Table(am not getting correct total in Table)

CALCULATE (

COUNTROWS(Table1), (FILTER( All(Table1), Table1[Priority] = 1 && Table1[Date] =selecteddate && Table1 [Que]=selectedque)),
TREATAS ( CR_tbl, Table1[comp], Table1[Reg] )
)

Regards,

Chandrashekar B

Re: Summarize function

amitchandak — Mon, 17 Jan 2022 06:58:50 GMT

Chandrashekar , summarize will use columns what is there in visual display(grouped/un summarized) , example if comp is used in visual

CALCULATE (
sumx(addcolumns(summarize(Table1[comp]), "_1"
COUNTROWS(Table1), (FILTER( All(Table1), Table1[Priority] = 1 && Table1[Date] =selecteddate && Table1 [Que]=selectedque)),
TREATAS ( CR_tbl, Table1[comp], Table1[Reg] ) ),[_1]
))

Re: Summarize function

Chandrashekar — Mon, 17 Jan 2022 07:19:21 GMT

Hello Amit,

am getting incorrect total in Table may I know how to fix this issue. Should I use Summarize in measures or any other way to fix it?

Re: Summarize function

amitchandak — Mon, 17 Jan 2022 07:39:06 GMT

Chandrashekar ,If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Re: Summarize function

Chandrashekar — Mon, 17 Jan 2022 09:42:08 GMT

Hello Amit,

Thanks and got the solution.

Regards,

Chandrashekar B