Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
hey guysm I have this formula:
Proud to be a Super User!
Solved! Go to Solution.
Hi @StefanoGrimaldi
Please try below code
DIVIDE(
[.Saldo Ejecutado Indicadores],
CALCULATE(
[.Saldo Ejecutado Indicadores],
REMOVEFILTER('Indicadores Financieros'[Indicador]),
'Indicadores Financieros'[Categoria de cuenta] = "4. Ingresos"
)
)
If your requirement is solved, please make sure to MARK AS SOLUTION and help other users find the solution quickly. Please hit the LIKE button if this comment helps you.
Thanks
Pijush
Hi @StefanoGrimaldi
Please try below code
DIVIDE(
[.Saldo Ejecutado Indicadores],
CALCULATE(
[.Saldo Ejecutado Indicadores],
REMOVEFILTER('Indicadores Financieros'[Indicador]),
'Indicadores Financieros'[Categoria de cuenta] = "4. Ingresos"
)
)
If your requirement is solved, please make sure to MARK AS SOLUTION and help other users find the solution quickly. Please hit the LIKE button if this comment helps you.
Thanks
Pijush
nop, still same behaviour its dividing by the grand total as if its ignoring the column filter.
Proud to be a Super User!
never mind it worked, need to change a column was using the wrong one, thanks
Proud to be a Super User!