Forum Discussion

pvaldiviag's avatar
pvaldiviag
New Member
10 years ago

Bad calculation using IF (Matrix)

Hello, Im using this formula Ventas$N = IF([SUBS_C], //TRUE DIVIDE(TOTALYTD(SUM(Metricas[Monto]),Tiempo[Fecha],'Terminos Financieros'[TF_id]=25),CALCULATE(SUM(Tiempo[TipoCambio])),"ERROR"), //F...
Need Help
Baskar's avatar
Baskar
Resident Rockstar
10 years ago

Hi Pvaldiviag,

 

There is no prob with your formula, this the prob on power bi Total, Its nature is calculate entire sum. 

I think in prob on power bi end....