CODEWITHSUNDEEP
powerbipowerquerypowerbi-custom-visuals
ashish1780
ashish1780

Reputation: 47

Calculate % of two columns Power BI

I want to calculate % of two columns which are already in %.

I want to calculate formula like

Target achieved= ACTUAL/TARGET

But here is ACTUAL is already a measure/calculated metrics so I'm not able to divide these two columns.

Any help would be appreciated..

enter image description here

Upvotes: 1

Views: 2590

Answers (1)

Michael Korotkov
Michael Korotkov

Reputation: 313

Make sure both target and actual are actually numbers and not strings. You can do it in transform data (aka Power Query) part, before data is loaded into the report.

data transformation

After that you should be able to create the measure you want, e.g. something like that:

measure % completed

UPDATE : What happens if Actual is not a column, but a measure?

If Actual measure is based on the columns in the same table as target you shouldn't have a problem. You cannot combine measure and column in the same formula. Measure is an aggregated field and needs to be grouped by another field (if you are familiar with SQL,think of SUM and GROUP BY). Coming back to your problem, you need to create measure out of "Target" column as well (notice I have in the formula SUM('Table'[Plan]) which makes it a measure). Than you can use both of them in the formula, but of course you need to "group" them by something(e.g. date) otherwise it will just show you a total. formula with Actual as measure

Upvotes: 1

Related Questions