Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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 ...
Need Help
themistoklis's avatar
themistoklis
Community Champion
7 years ago

Anonymous

 

Try this formula:

 

Measure = SUMX (
                VALUES ( Table[SurgeryRoom] );
                CALCULATE ( SUM ( Table[NumofSurgeries] ) )
            )
Anonymous's avatar
Anonymous
Not applicable
7 years ago
thank you for you answer :)
where?
the total is automatic with the table..
  • themistoklis's avatar
    themistoklis
    Community Champion
    7 years ago

    Anonymous

     

    Createa new Measure and add the formula.

     

    Right click on the table on the left hadn side --> New Measure

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago
      It doesnt exists in analysis connection ..
      • v-yuta-msft's avatar
        v-yuta-msft
        Community Support
        7 years ago

        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.