Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
@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,
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.
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |