Data count is mismatched in Table control

[Anonymous]

Hi All,

i need show the data in two tables, one table showing data on service specific means on daily basis how many record is created.

and another table showing the summary of the first table.

Currently i am using the desktop application of Power Bi

below are sample data i have provided can you please suggest how to deal with this issue.

Created on date Oncall OnBook OnService
1/1/2019 1 1 1
1/2/2019 2 3 2
1/3/2019 3 2 4
1/4/2019 1 1 2
1/5/2019 1 3 5
1/6/2019 3 5 6
Total 11 15 20

Service Name Total
OnCall 12
OnBook 18
OnService 20

Regards,

Jyotsna

[v-diye-msft · Accepted solution]

Hi @Anonymous 

Please let me know if you'd like to get below result:

You can create a calculated table as the second one:

Table 2 = UNION(
    SUMMARIZE(
        'Table'
        ,"Service Name", "Oncall"
    
    )
    ,SUMMARIZE(
        'Table'
        ,"Service Name", "OnBook"
    
    )
    ,SUMMARIZE(
        'Table'
        ,"Service Name", "OnService"
   
    )
)

Then add the measure:

Total = var a = SUM('Table'[OnBook])
var b = SUM('Table'[Oncall])
var c = SUM('Table'[OnService])
Return
SWITCH(MAX([Service Name]),"Onbook",a,"Oncall",b,"OnService",c)

Pbix attached.