Skip to main content
cancel
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

Reply
PowerBIOrg
Resolver II
Resolver II

Sum by Category/Type without ignoring other filters

Hi All, 

 

I would like to sum up the amount by Type. I know that ALLEXCEPT work in Scenario 1. 

 

Is there anyone can help to create a measure that could work for all scenario?

 

     Scenario 1Scenario 2Scenario 3Scenario 4
         
    Filter 1 (Category):All SelectedmAll Selectedm
    Filter 2 (Year):All SelectedAll Selected20202021
         
Claim NoTypeCategoryYearAmountSum by TypeSum by TypeSum by TypeSum by Type
axl2019100600NANANA
dxm2020300600500300NA
exm2019200600500NANA
bym2021100200100NA100
fyn2021100200NANANA
czn2020100100NA100

NA

 

Thanks!

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

Hi, @PowerBIOrg 

Please check the below.

 

Picture1.png

 

Sum by Type Measure =
CALCULATE (
SUM ( 'Table'[Amount] ),
ALLSELECTED ( 'Table' ),
VALUES ( 'Table'[Type] )
)

 

 

https://www.dropbox.com/s/sgydb85cmf1uuum/powerbiorg.pbix?dl=0 

 

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here and Go to My LinkedIn Page


View solution in original post

1 REPLY 1
Jihwan_Kim
Super User
Super User

Hi, @PowerBIOrg 

Please check the below.

 

Picture1.png

 

Sum by Type Measure =
CALCULATE (
SUM ( 'Table'[Amount] ),
ALLSELECTED ( 'Table' ),
VALUES ( 'Table'[Type] )
)

 

 

https://www.dropbox.com/s/sgydb85cmf1uuum/powerbiorg.pbix?dl=0 

 

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here and Go to My LinkedIn Page


Helpful resources

Announcements
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.

Top Solution Authors
Top Kudoed Authors