Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
BlueNoze
New Member

Hacer un total de varias columnas usando múltiples filtros

Hola a todos

He intentado buscar la respuesta a este, pero no puedo encontrar la respuesta más im muy nuevo a BI para apreciar su paciencia.

Así que necesito añadir una visualización de tarjetas (que sé hacer 🙂 pero necesita calcular la suma de las 3 columnas;

"HAccountTotal" (Cuando "Estado de Contratación" - "Sin pagar") + "RAccountTotal" (Cuando "RepairStatus" - "No pagado") + "RSTotal" (Cuando "RandSStatus" - "No pagado")

BlueNoze_0-1593510338306.png

Espero que esto tenga sentido. Gracias

3 REPLIES 3
amitchandak
Super User
Super User

@BlueNoze , Probar como

sumx(Table, switch(true(),Table[Hire Status] = "Unpaid",Table[HAccountTotal],
      Table[RepairStatus] = "Unpaid",Table[RAccountTotal],
      Table[RandSStatus]= "Unpaid" ,Table[RSTotal],blank()))
Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
DataZoe
Microsoft Employee
Microsoft Employee

Hola @BlueNoze ,

Por favor, intente esto como una medida:

YourMeasure ?

calculate(sum(TableName[HAccountTotal]),TableName[Hire Status] á "Unpaid")

+ calculate(sum(TableName[RAccountTotal]),TableName[RepairStatus] á "Unpaid")

+ calculate(sum(TableName[RSTotal]),TableName[RandSStatus]- "Unpaid")

Respectfully,
Zoe Douglas (DataZoe)



Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/

Funcionó perfectamente Gracias!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors