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[Pri...
  • Chandrashekar's avatar
    Chandrashekar
    4 years ago

    Hello Amit,

     

    Thanks and got the solution.

     

    Regards,

    Chandrashekar B

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.

      • Chandrashekar's avatar
        Chandrashekar
        Resolver III
        4 years ago

        Hello Amit,

         

        Thanks and got the solution.

         

        Regards,

        Chandrashekar B