Forum Discussion

Chandrashekar's avatar
Chandrashekar
Resolver III
4 years ago
Solved

Summarize function

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

  • Chandrashekar's avatar
    Chandrashekar
    4 years ago

    Hello Amit,

     

    Thanks and got the solution.

     

    Regards,

    Chandrashekar B

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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's avatar
      Chandrashekar
      Resolver III
      4 years ago

      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's avatar
        amitchandak
        Super User
        4 years ago

        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.