Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Needed Help!!!

Submitted by Anonymous on ‎02-07-2019 12:19 PM

Hi, I have a question when I make this formula CEL 2 = SUM (TarjaLote [TotalNew]) * (SUM ('R 33' [PorPepa]) - [Quality Value]) * SUM ('R 33' [PorSinDefIn]) * ( SUM ('R 33' [Per Rooms]) + [Room Cut Value]) * (SUM ('R 33' [For Extra]) + SUM ('R 33' [PorLight])) gives me these values ​​2768.28,2459.12, 3291.13 and the total sum remains in Total 631509.42 How can I solve this formula.
I am working with a parameter that some values ​​must change

 

Sin título.png

Status: Needs Info
See more ideas labeled with:
2 Comments (2 New)
Comments
Anonymous
Not applicable
‎02-11-2019 05:56 PM

@Anonymous,

Please create the following measure and check if it returns your expected result.

Measure = IF(COUNTROWS(VALUES(Table[Lote 1]))=1, [CEL 2],SUMX(VALUES(Table[Lote 1]),[CEL 2]))


If you still get wrong result, please share sample data of your tables here so that we can test.

Regards,
Lydia

Anonymous
Not applicable
‎02-11-2019 05:56 PM
 
Idea Statuses