cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
deepak21 Frequent Visitor
Frequent Visitor

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

Accepted Solutions
Tahreem24 Senior Member
Senior Member

Re: SUMIF in Power BI

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

I hope now it helps!

View solution in original post

4 REPLIES 4
Tahreem24 Senior Member
Senior Member

Re: SUMIF in Power BI

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.
deepak21 Frequent Visitor
Frequent Visitor

Re: SUMIF in Power BI

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

Tahreem24 Senior Member
Senior Member

Re: SUMIF in Power BI

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.
Tahreem24 Senior Member
Senior Member

Re: SUMIF in Power BI

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

I hope now it helps!

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (3,862)