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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Commutative column not Sum correctly

Hey all,

 

I have my dataset below, Column, Column 2, Column3, Column4  and Measure 2 are calculated columns and measuures i have created. measure should be a commlative of column 2. In the screenshot below var c1 is column1, c2 is column3 and c3 is column2.

idanconley_0-1639044506371.pngidanconley_1-1639044528748.png

 

thanks!

3 REPLIES 3
amitchandak
Super User
Super User

@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

One change

change the last sumx as

Sumx(Values('Trending in excel'[age at awareness date]), c3)

 

//5 the last line. rest should be same

Anonymous
Not applicable

and what do you mean by that "//5 the last line. rest should be same"?

i did not understand

thanks!

Anonymous
Not applicable

I change as you said, and now it appears like this:

idanconley_0-1639046074500.png

the sample data from 'Trending in excel':

idanconley_1-1639046371476.png

and from IB pumps:

idanconley_2-1639046449869.png

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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