Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Anonymous
Not applicable

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 1610
 P114 
 P124 
 P134 
 P144 
G 2 1820
 P216 
 P226 
 P236 
G 3 1230
 P316 
 P326 
G 4 440
 P414 
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

1 ACCEPTED SOLUTION
Datatouille
Solution Sage
Solution Sage

Hi Ana,

 

Try this measure:

 

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

 

 

View solution in original post

2 REPLIES 2
Datatouille
Solution Sage
Solution Sage

Hi Ana,

 

Try this measure:

 

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

 

 

Anonymous
Not applicable

Thanks, Tristan !!

 

It works ok, Smiley Happy

 

Best regards 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.