Forum Discussion
Data count is mismatched in Table control
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
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.
1 Reply
- v-diye-msft
Community Support
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.