cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DiegoReis Member
Member

Don't show Total

dont_total.PNG

Don't show total =/

 

This is a measure wiht IF another measure don't heave IF

 

problem happens on the desktop and the service

 

 

 

 

 

Total comprometido_old when I expot to Excel R$ 7.400,00

Measuers:

 

COMPROMETIDO_old = IF(CALCULATE([TOTALPEDIDO] - ([ENTRADACUSTO] + [ENTRADACONTABIL]);RELATEDTABLE(PEDIDO)) < 0 ; 0 ; CALCULATE([TOTALPEDIDO] - ([ENTRADACUSTO] + [ENTRADACONTABIL]);RELATEDTABLE(PEDIDO)))

 

ENTRADACUSTO = CALCULATE([valor_Custo]; CUSTO[FLAGCOMP] = TRUE())+0

 

ENTRADACONTABIL = CALCULATE([Valor_Contabil]; CONTABIL[FLAG] = TRUE())+0

 

TOTALPEDIDO = CALCULATE(SUM(PEDIDO[VALOR_PED]);PROJETOS[ENCERRADO] = 13; PEDIDO[ELIM_PED] <> "L"; PROJETOS[ORDEM] <> 0; ALL(MES[MÊS]); ALL(ANOS[ANO]))

 

Please help me =D

 

Thanks

2 REPLIES 2
v-xjiin-msft Super Contributor
Super Contributor

Re: Don't show Total

Hi @DiegoReis,

 

=> problem happens on the desktop and the service

 

In your scenario, what is the problem? Did you mean the grand total of measure comprometido_old was wrong? And your expected grand total result of comprometido_old is 740000?

 

Sorry but I'm not quite understand about your issue. Could you please elaborate it? By the way, if you can share us some sample data which can help us repro your issue. It'll help us more to figure out where the issue is.

 

Thanks,

Xi Jin.

DiegoReis Member
Member

Re: Don't show Total

Thanks Xi Jin.

 

Well, the problem is that it does not show the total, compromised_old is a measure of the monetary type, it generates a rest of the fields that I listed above.

 

Look this file: Link To Donwload

 

Thanks