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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
nbrandborg
Helper II
Helper II

Change from measure to calculated column / percentage of sales

Hi all,

I have following working measure in my dataset, but I need to have it as a calculated column as I need the values to be fixed when filtering.

 

Can anyone help me to translate the measure below?

 

Percentage of Sales= DIVIDE(SUM('Regional Sales'[Realised Sales]),CALCULATE(SUM('Regional Sales'[Realised Sales]),FILTER(ALLSELECTED('Regional Sales'),'Regional Sales'[Material] = MAX('Regional Sales'[Material]))))

It does follwing percentage calculation:
nbrandborg_0-1632808714780.png


Best regards!



1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@nbrandborg , Try a new column like

 

Percentage of Sales= DIVIDE(('Regional Sales'[Realised Sales]),CALCULATE(SUM('Regional Sales'[Realised Sales]),FILTER(ALLSELECTED('Regional Sales'),'Regional Sales'[Material] = earlier('Regional Sales'[Material]))))

View solution in original post

2 REPLIES 2
nbrandborg
Helper II
Helper II

It worked. Thank you @amitchandak !

amitchandak
Super User
Super User

@nbrandborg , Try a new column like

 

Percentage of Sales= DIVIDE(('Regional Sales'[Realised Sales]),CALCULATE(SUM('Regional Sales'[Realised Sales]),FILTER(ALLSELECTED('Regional Sales'),'Regional Sales'[Material] = earlier('Regional Sales'[Material]))))

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.