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

Sum of the measure

Hi All,

 

Can some one help me to get the sum of the measure number that i have created. At an ro level i want to show if the particular account is earning more than 10% then 1 else 0.

The same formula apply to the total as well. So basically i don't want the same to be applied. i just need to do the total of all the values in the column i.e Advisory SLI (1+1=2).

 

Sum.jpg

 

 

 

Regards,

Ranjan

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

Try Like

sumx(summarize('Table','Table'[Account],"_acc",[Advisory %]),if ([_acc]>0.1,1,0))

 

Appreciate your Kudos.

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

Try Like

sumx(summarize('Table','Table'[Account],"_acc",[Advisory %]),if ([_acc]>0.1,1,0))

 

Appreciate your Kudos.

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.