Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hi Ana,
Try this measure:
Total Budget Final = IF( NOT (ISFILTERED ('Product'[Product]) ) , [Total Budget] ,BLANK() )
Hi Ana,
Try this measure:
Total Budget Final = IF( NOT (ISFILTERED ('Product'[Product]) ) , [Total Budget] ,BLANK() )
Thanks, Tristan !!
It works ok,
Best regards
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |