CODEWITHSUNDEEP
daxvisualizationpowerbi-desktop
sabre28
sabre28

Reputation: 13

Power BI Table - Divide values from different Rows and Columns

I have a table that lists some KPI's and where some of the rows have a measure that is calculated differently, and I am wanting to divide two values from a different row and column.

I have a KPIId that can get me the row, and I have a measure for Sales, Cost, GP, but what I am trying to get is on KPIId 7, in the GP% column: the $17,534 from kpi 7 GP, divided by the sum of $83,990 + $225 from KPI 3 & 4. So ideally, on kpi 7 under GP%, it should be 20.82%

I have tried a Calculation using the filter option to get only the KPI values I want, but it has not worked yet. Hopefully someone can shed some light on this! Appreciated!

Here is the function I tried

Here is a snippet of what the table looks like.

Upvotes: 0

Views: 25

Answers (0)

Related Questions