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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
macg1976
New Member

Cálculo peso relativo DAX-PBI

Necesito ayuda con las formulas DAX para cálcular la tercera columna. La primera fila es el cálculo de 100/300 (300 es la suma de proyectos tipo A).....parece simple pero no me resulta con distintas funciones.

 

gracias, Mauricio

 

TipoPresupuestoPeso relativo por tipo
Proyecto tipo A1000,333
Proyecto tipo A800,267
Proyecto tipo A1200,400
Proyecto tipo B900,375
Proyecto tipo B1500,625
1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

Hi @macg1976 ,

 

You can add a calculated column with below formula:

Diff =
[Presupuesto]
    / CALCULATE (
        SUM ( T2[Presupuesto] ),
        FILTER ( ALL ( T2 ), [Tipo] = EARLIER ( T2[Tipo] ) )
    )

 

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

Hi @macg1976 ,

 

You can add a calculated column with below formula:

Diff =
[Presupuesto]
    / CALCULATE (
        SUM ( T2[Presupuesto] ),
        FILTER ( ALL ( T2 ), [Tipo] = EARLIER ( T2[Tipo] ) )
    )

 

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Excellent, thank you very much ..... greetings

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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