Forum Discussion
DAX Calculation Divide two Fact tables is giving wrong output
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(ISBLAN...
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
Community Champion
Community ChampionHi Anonymous
What do you get when you place [Budget gross invoiced sales EUR YTD] in the same table visual?
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
Anonymous
The 5th column in the table visual is [Budget monthly gross invoiced EUR] not [Budget gross invoiced sales EUR YTD]
sorry, indeed the field is created like this: Budget total gross invoiced EUR =Sum([Gross Invoiced_new])