Solved: How to make one of filters not affecting - Page 2

BIdeveloper · ‎09-28-2018

Hi,

I am in total lock with easy thing. I want to make a measure of % of total based on one filter. How to write this formula?

I want to make a measure that I tick from filter Apple and then it shows the amount of apples as a percentage of all fruits. I know this is simple, but how to write the formula?

Fruit	Amount
Apple	3
Carrot	4
Peach	2
Apple	1
Carrot	2
Peach	5

v-frfei-msft · ‎10-09-2018

Hi @BIdeveloper,

We can create two calculated table to use as slicer.

Region = DISTINCT(Table1[Region])

Fruit = DISTINCT(Table1[Fruit])

Then create a measure to work on it.

new1 = 
var fru = SELECTEDVALUE(Fruit[Fruit])
var reg = SELECTEDVALUE(Region[Region])
var sele = CALCULATE(SUM(Table1[Amount]),FILTER(Table1,Table1[Fruit]=fru&& Table1[Region]=reg))
var alls = CALCULATE(SUM(Table1[Amount]),ALLSELECTED(Table1))
return 
sele/alls

For more details, please check the pbix as attached.

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

How to make one of filters not affecting

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly