Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
113 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |