cancel
Showing results for
Did you mean:
Frequent Visitor

## Calculation for one single level

Hi everyone

I have for tables:

Invoice: Product + Qty

Product: Product + Product Group

Product Group: Product Group

Budget: Product Group + Budget

Summarizing: Sales by Products and Budget by Product Groups

Product GroupProductTotal SalesTotal Budget

 G 1 16 10 P11 4 P12 4 P13 4 P14 4 G 2 18 20 P21 6 P22 6 P23 6 G 3 12 30 P31 6 P32 6 G 4 4 40 P41 4 G 5 50 P51

I'm using IF HASONEVALUE(Product[Product]),

I've obtained the correct answer for the G1, G2, and G3; but G4 and G5 have just one product.

HASONEVALUE is not the solution for this case.

Regards from Spain,

Ana

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
MVP

## Re: Calculation for one single level

Hi Ana,

Try this measure:

Total Budget Final = IF( NOT (ISFILTERED ('Product'[Product]) ) , [Total Budget] ,BLANK() )

2 REPLIES 2
Highlighted
MVP

## Re: Calculation for one single level

Hi Ana,

Try this measure:

Total Budget Final = IF( NOT (ISFILTERED ('Product'[Product]) ) , [Total Budget] ,BLANK() )

Highlighted
Frequent Visitor

## Re: Calculation for one single level

Thanks, Tristan !!

It works ok,

Best regards

Announcements

#### August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

#### Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

#### Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

#### Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors