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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

SUMIF in Power BI

Hi all,

 

I have this table in Power BI,

 

CategoryTotal USD

AA21
AC23
AG67
AI44
AO56
AP9
AE34
AV12
AJ89
AZ7
AI34
AW88
AQ9
AC35
AE87
AG93
AI98
AP75
AL49
AS39
AH57
AP74
AE29
AI85
AY48

 

Now, I would like to create a graph which will show the sum of only "AI". I would like to do the sum of AI like we do it in Excel using the function SUMIF. But, I am unable to do so in Power BI. 

Can someone please help me?

 

Appreciate your help.

 

Regards,

1 ACCEPTED SOLUTION

CALCULATE (SUM(Table[Total Usd]), Table[Category]="AI")

I hope now it helps!
Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

View solution in original post

4 REPLIES 4
Tahreem24
Super User
Super User

Please give a try to below measure:
Calculate (sum(total usd), category ="AI")

Please give Kudos to this effort and accept this as a solution if it helps you.
Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

CALCULATE (SUM(Table[Total Usd]), Table[Category]="AI")

I hope now it helps!
Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard
Anonymous
Not applicable

Hi @Tahreem24 ,

 

Are you sure about the way you have written the function? I am afraid whether it is right, because it is showing me error.

 

Regards

Hi Deepak,

I hope there is auto text completion functionality available in your power bi desktop. I just gave you structure of dax formula.

Just enter the name of column in given dax function.
Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors