cancel
Showing results for
Did you mean:
Post Partisan

## How to find top accounts profit and normal accounts profits difference in power bi

Hi Team,

I need top accounts profit and normal accounts profits difference in power bi so how can I do that in power bi.

Example actually I want the column like diff in profit in power bi

 Accounts Profit Rank Difference From top Rank Diff in Profit A 4030 2 1 0 B 3424 4 3 -606 C 4348 1 0 318 D 1087 7 6 -2943 E 2070 6 5 -1960 F 2702 5 4 -1328 G 3696 3 2 -334

Thanks,

Arvind

1 ACCEPTED SOLUTION
Microsoft

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 REPLIES 6
Super User

Try this for your calculated column if you want the rank in 'Difference From top Rank' as reference (as shown in your expected result):

`Column = Table1[Profit]-LOOKUPVALUE(Table1[Profit];Table1[Difference From top Rank];1)`

Although I think you might have made a mistake and want this, i.e., taking 'Rank' as reference:

`Column2 = Table1[Profit]-LOOKUPVALUE(Table1[Profit];Table1[Rank];1)`
Post Partisan

Hi @AlB ,

Actually Rank and Difference From top rank is a measure which is created by me so how can lookup in that scenario.

Post Partisan

Hi @AlB ,

Any Update?

Thanks,

Arvind

Super User

I cannot help unless you describe the issue properly. You have measures, you claim. What is the code for those measures? Where and how are you using them? What is the table that you show, a table visual? What are the tables in your data model that would play a role in the calculations and their contents/relationships?

You could also just create a calculated column with the rank and then add the calculated column that I described earlier. That would probably be simpler

Post Partisan

Hi @AlB ,

Microsoft

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### 2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

#### Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

#### 2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors