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 ...
Anonymous
Try this formula:
Measure = SUMX (
VALUES ( Table[SurgeryRoom] );
CALCULATE ( SUM ( Table[NumofSurgeries] ) )
)- thank you for you answer :)
where?
the total is automatic with the table..Anonymous
Createa new Measure and add the formula.
Right click on the table on the left hadn side --> New Measure
- It doesnt exists in analysis connection ..