topic Re: DAX Calculation Divide two Fact tables is giving wrong output in DAX Commands and Tips

DAX Calculation Divide two Fact tables is giving wrong output

Anonymous — Fri, 12 May 2023 17:08:01 GMT

hi,

have this measure: (show translation version):

VAR _CALC = DIVIDE
('Fact_Sales'[Gross Invoiced Sales EUR TY],'Fact_Sales budget'[Budget gross invoiced sales EUR YTD])

RETURN
/*IF( NOT(ISBLANK( _CALC ) ), _CALC, 0) */
_CALC

but if you look at this output than it is wrong:

the first column with the percentage should be 90.1%.

anyone ideas how this can be solved

thnx

tamerj1 — Fri, 12 May 2023 17:24:51 GMT

Hi Anonymous

What do you get when you place [Budget gross invoiced sales EUR YTD] in the same table visual?

Anonymous — Fri, 12 May 2023 17:35:50 GMT

Hi Tamerj1

it is already in, see the 5th column Budget Total gross invoiced YTD

tamerj1 — Fri, 12 May 2023 17:49:30 GMT

Anonymous

Are you sure you have created a measure not a column? All of them are measures?

Anonymous — Fri, 12 May 2023 17:58:52 GMT

it is a measure as you can see:

Budget gross invoiced sales EUR YTD=

VAR _MONTH = MONTH(TODAY())
RETURN CALCULATE([Budget monthly gross invoiced EUR], [Dim_InvoiceDate][Month nr]<=_MONTH)

tamerj1 — Fri, 12 May 2023 18:15:28 GMT

Anonymous

The 5th column in the table visual is [Budget monthly gross invoiced EUR] not [Budget gross invoiced sales EUR YTD]

Anonymous — Fri, 12 May 2023 18:38:35 GMT

sorry, indeed the field is created like this: Budget total gross invoiced EUR =Sum([Gross Invoiced_new])

tamerj1 — Fri, 12 May 2023 19:29:07 GMT

Anonymous

I mean perhaps the division is correct but your looking at the wrong measures