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 ...
thank you for you answer :)
where?
the total is automatic with the table..
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 ..
Anonymous,
It doesnt exists in analysis connection ..So you are using power bi live connection mode to connect to SSAS, right? If you are, you can create measure using SUM in SSAS side.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.- Right, Im using live connection.
The "NumberOfSurgeries" is a measure in SSAS- its distinct count of surgery-code.
When im adding it to the table it works fine. the total is fine. when im adding a slycer/filter- the total doesnt react and the total keeps showing the total of all the rooms.
by the way, when im processing the cube and refresh the report- the total shows the right number. but when i add a room and remove ir from the slycer - the total shows the total of all the rooms agin
