Forum Discussion
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.
Thanks for your ideas,
Regards from Spain,
Ana
Hi Ana,
Try this measure:
Total Budget Final = IF( NOT (ISFILTERED ('Product'[Product]) ) , [Total Budget] ,BLANK() )
2 Replies
Hi Ana,
Try this measure:
Total Budget Final = IF( NOT (ISFILTERED ('Product'[Product]) ) , [Total Budget] ,BLANK() )