POWER BI - Create a measure to compare Forecast vs Sales

Question

Here,I had a measure which compare forecast vs sales in Power Bi,here is the logic which I have created which has logic at the beginning of the Jan 2018 which shows the sales for the whole year,and here,how can I compare forecast vs sales

Answer 1

Use the following measures:

Forecast Qty:=CALCULATE ( 
    SUM ( SourceTable[Qty] ),
    SourceTable[Type] = "Forecast"
)

Sold Qty:=CALCULATE ( 
    SUM ( SourceTable[Qty] ),
    SourceTable[Type] = "Sold" 

) 

Sales % Forecast:=DIVIDE ( 
    [Sold Qty],
    [Forecast Qty],
    BLANK() 

) 

and your following visualization looks like this

Want to learn more about Power BI? Check out today: Power BI course