cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
kstabler
New Member

Columna de suma si otro valor de columna es cero

Hey, Tratando de crear una medida de contar QTY de tipos de unidad en un edificio que no tienen un patio mediante la correlación de mi columna 'QTY de tipos de unidad' con mi columna 'patio SF'.

4 -
1 -
4 -
1 -
387
476
170
1264
378
178
178
3 -
6 -
1 -
- 97
474
474
3183
174
2 REPLIES 2
jdbuchanan71
Super User
Super User

@kstabler

Pruébalo. Asumo que desea sumar los importes en la primera columna. Deberá cambiar los nombres de tabla y campo para que coincidan con el modelo.

Non-patio units =
CALCULATE ( SUM ( YourTable[Qty of unit types] ), YourTable[Patio SF] = 0 )

@jdbuchanan71

¡Muchas gracias que funciona!

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors