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 ...
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
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
Anonymous,
In the format pane, select don't summarize.
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.