cancel
Showing results for
Did you mean:
Highlighted
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() )

Frequent Visitor

## Re: Calculation for one single level

Thanks, Tristan !!

It works ok,

Best regards

Announcements

#### Meet the 2020 Season 2 Power BI Super Users!

Find out who's part of the program this season, and welcome the new Super Users.

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

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

#### July 2020 Community Highlights

Learn about the exciting things that happened in July.

#### Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

#### Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Top Solution Authors
Top Kudoed Authors