Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
  • Anonymous's avatar
    Anonymous
    3 years ago

    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)

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Tamerj1

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

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Anonymous 

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