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
svc_powerbi_dk
Regular Visitor

Slow Performance Switch

Hi Guys,

My DRE is very slow 1 table 300k rows, help me? with each measure it double, single table, 15 columns

com.PNGthe time

Real = CALCULATE(
SWITCH (
TRUE (),
MAX ( indicador[id_indicador] ) = 1, [DrePrecoMedioVenda],
MAX ( indicador[id_indicador] ) = 2, [QtdVenda],
MAX ( indicador[id_indicador] ) = 3, [DreReceitaBruta],
MAX ( indicador[id_indicador] ) = 4, [DreDevolucao],
MAX ( indicador[id_indicador] ) = 5, [DreImposto],
MAX ( indicador[id_indicador] ) = 6, [DreOutrasDeducoes],
MAX ( indicador[id_indicador] ) = 7, [DreReceitaLiquida],
MAX ( indicador[id_indicador] ) = 8, [DreCpv],
MAX ( indicador[id_indicador] ) = 9, [DreFrete],
MAX ( indicador[id_indicador] ) = 10, [DreArmazenagem],
MAX ( indicador[id_indicador] ) = 11, [DreLucroBruto],
MAX ( indicador[id_indicador] ) = 12, FORMAT ( [DrePercLucroBruto], "0%"),
MAX ( indicador[id_indicador] ) = 13, [DreDespAdmin],
MAX ( indicador[id_indicador] ) = 14, [DreComisoes],
MAX ( indicador[id_indicador] ) = 15, [DreDespVenda],
MAX ( indicador[id_indicador] ) = 16, [DreDespVendaCorp],
MAX ( indicador[id_indicador] ) = 17, [DreDespTotal],
MAX ( indicador[id_indicador] ) = 18, FORMAT ( [DrePercDesp], "0%"),
MAX ( indicador[id_indicador] ) = 19, [DreOutrasDesp],
MAX ( indicador[id_indicador] ) = 20, [DreEquival],
MAX ( indicador[id_indicador] ) = 21, [DreEbit],
MAX ( indicador[id_indicador] ) = 22, FORMAT ( [DrePercEbit], "0%"),
MAX ( indicador[id_indicador] ) = 23, [DreDepreciacaoContabil],
MAX ( indicador[id_indicador] ) = 24, [DreAmortizacao],
MAX ( indicador[id_indicador] ) = 25, [DreEbitda],
MAX ( indicador[id_indicador] ) = 26, FORMAT ( [DrePercEbitda], "0%"),
MAX ( indicador[id_indicador] ) = 27, [DreCmdbUsagaap],
MAX ( indicador[id_indicador] ) = 28, [DreEbitdaCmdbUsgaap],
MAX ( indicador[id_indicador] ) = 29, FORMAT ( [DrePercEbitdaCmdbUsgaap], "0%"),
MAX ( indicador[id_indicador] ) = 30, [DreDespFinan],
MAX ( indicador[id_indicador] ) = 31, [DreLucroAntesImpo],
MAX ( indicador[id_indicador] ) = 32, [DreImpSemLucro],
MAX ( indicador[id_indicador] ) = 33, [DreLucroLiq]
), resultado[tipo] = "real")
This measure are just a sum
Ty
1 REPLY 1

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.

Top Solution Authors