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. Cu...
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.
v-diye-msft
Community Support
Community SupportHi 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.