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
PaulMcDk
Frequent Visitor

DIVIDE and PERCENTAGE

Dear community,

 

i'd need your support as i'm trying to do - apparently - a very easy thing but ... i can't 🙂

I have a table loaded with 2 simple measures: count number of trips.

I created another simple measure which is the difference between the two columns.

PaulMcDk_0-1626942902307.png

 

So you see that's super easy.  I would love to add a measure called Delta trip % which is basically the (Trip Actual / Trip Budget ) -1 and % format.

 

I then created this whici partially works

As  you see, % is ok but the same table with new measure is creating :

i) first top blank line

ii) other line "not needed"  such as INDIA and ROMANIA.

Any suggestion ?

 

thank you very much for your great support !

 

PaulMcDk_1-1626943045838.png

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@PaulMcDk , Try like

 

divide([Trip Actual] -[Trip Budget] , [Trip Budget] , blank())

 

or

if(isblank([Trip Actual] ) || isblank([Trip Budget]), blank(), divide([Trip Actual] -[Trip Budget] , [Trip Budget] , blank()) )

 

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@PaulMcDk , Try like

 

divide([Trip Actual] -[Trip Budget] , [Trip Budget] , blank())

 

or

if(isblank([Trip Actual] ) || isblank([Trip Budget]), blank(), divide([Trip Actual] -[Trip Budget] , [Trip Budget] , blank()) )

 

thanks!

first like did work

 

p

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.