Dividing values that are on the same column based on a criteria

[DanielBispo]

Hello!

I have a table with three columns, as the image shows.

I want to make a DAX formula that i can put into a visual that divides the values corresponding to actual to the values corresponding to budget. Something like if column "Atributte" = Actual, then sum. And if column "Atributte" = Budget, sum. Then divide those two values so it corresponds to each row and topic on my table.

[Jihwan_Kim]

Hi,

Please check the below picture and the attached pbix file.

Actual divide by Bugdet: =
VAR _actual =
    CALCULATE ( SUM ( Data[Values] ), Data[Attribute] = "Actual" )
VAR _budget =
    CALCULATE ( SUM ( Data[Values] ), Data[Attribute] = "Budget" )
RETURN
    DIVIDE ( _actual, _budget )