Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I
Helper I

How can I find the Top N project Types based on Amount in power Bi ?

How can I find the Top N Project Types by Transaction Amount ? 

When my data looks like 

  1. id  project type Amount
  2.  1  Type A 100
  3.  4 Type A  300
  4. 5 Type B 100
  5.  2 Type C 100

I want the transaction Amount to roll up by Project type Type A (400) TypeB (100) and TypeC (100) and tope 1 project type by transaction will be Type A then. 


I want the Top N to be a dynamic parameter as well !

Is this possible ?


Currently I am creating a seperate table using summarize 


Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.