Forum Discussion
total doesnt work
Hi,
I have a PBI report (SQL Service Analysis direct connection) with a table showing number of surgeries by room, and slicer for RoomFilter.
table example:
SurgeryRoom NumOfSurgeries
a 1
b 1
c 1
total: 3
when I choose 2 rooms in the slicer, the total doesn't change.
table example:
SurgeryRoom NumOfSurgeries
a 1
b 1
total: 3
when i expect the total to be 2..
can you help with this problem?
thank you :)
I have a PBI report (SQL Service Analysis direct connection) with a table showing number of surgeries by room, and slicer for RoomFilter.
table example:
SurgeryRoom NumOfSurgeries
a 1
b 1
c 1
total: 3
when I choose 2 rooms in the slicer, the total doesn't change.
table example:
SurgeryRoom NumOfSurgeries
a 1
b 1
total: 3
when i expect the total to be 2..
can you help with this problem?
thank you :)
8 Replies
Anonymous
Try this formula:
Measure = SUMX ( VALUES ( Table[SurgeryRoom] ); CALCULATE ( SUM ( Table[NumofSurgeries] ) ) )Anonymous
Createa new Measure and add the formula.
Right click on the table on the left hadn side --> New Measure
Anonymous,
Click [SurgeryRoom] and [NumOfSurgeries] to the chart and click NumOfSurgeies-> Sum, then create a slicer based on [SurgeryRoom].
The result is like below:
Regards,
Jimmy Tao
