Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Hi @Anonymous,
=> 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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
78 | |
75 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |