cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pineapple77 Frequent Visitor
Frequent Visitor

DAX formula for percentage with filter

Hello,

 

I have stucked on that DAX formula and i would love to get some help Smiley Happy 

I want to visualise a percentage from the total of the same column.

I need the first value of the same column filtered to divide it to the original value of the same column, multyplied by 100 to get percentage.

I used CROSSFILTER and some other functions but i couldn't come up with a result.

 

I made a measure of the original value so i ca use it and called it "Percentage" and made a Crossfilter that looks like this but it doesn't work (" Percentage2 = CALCULATE([Percentage]; CROSSFILTER('Diversion_type (done)'[Weight];'_Diversions 2017/09'[Number];OneWay)) ")

 

Thank you!

 

Best Regards,

Pavlin Ivanov

2 REPLIES 2
Moderator v-sihou-msft
Moderator

Re: DAX formula for percentage with filter

@pineapple77

 

Can you share some sample data? 

 

In this scenario, if you just need to calculate the percent to total for current row value, you just need to specify ALLSELECTED() as filter to get the total. So your percentage measure can be like: 

 

Percentage=SUM([Measure])/CALCULATE([Measure],ALLSELECTED(Table))

Regards,

Highlighted
pineapple77 Frequent Visitor
Frequent Visitor

Re: DAX formula for percentage with filter

Diversion (COUNT).pngDiversion (WEIGHT).png

Hello,

Here is some sample data.

The column that i have to filter is located in (Diversions 09/2017) [Count] and i have to filter it by (Diversion Weight) [weight] which column is in another table. I have to get the SUM of [count] before the filter and the SUM of [count] after the filter.
Can i get the values this way or if you can give a tip how to do it another way.

 

Thank you,

Pavlin Ivanov

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 107 members 1,478 guests
Please welcome our newest community members: