Calculation for one single level

[Anonymous]

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.

Thanks for your ideas,

Regards from Spain,

Ana

[Datatouille · Accepted solution]

Hi Ana,

Try this measure:

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

[Anonymous]

Thanks, Tristan !!

It works ok, 

Best regards