Summarize function

[Chandrashekar]

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

[amitchandak]

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

[Chandrashekar]

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?

[amitchandak]

@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.

[Chandrashekar · Accepted solution]

Hello Amit,

Thanks and got the solution.

Regards,

Chandrashekar B