PowerBi Visual Filter Issue

[neodghale205889]

I am trying to create a formula in my power bi that will allow me to filter a visual primarily based on two measures.

So if measure 1+measure 2< 50%, I would want it to remove those catagories from my visual.

Is this possible? I can provide more context if needed.

[neodghale205889]

no sorry its too large and complex to share anything like that

[bhanu_gautam]

Can you share sample data or PBIX file of use case

[neodghale205889]

Hi I think the measure is not working correctly because when it filters Grade 1 below 50% and Grade 2 below 50% is works. However when I use grade1+grade2 measusure we made, it is only removing items if they both are below 50%, not if they total 50%. do you know how to fix this?

[bhanu_gautam]

@neodghale205889 ,Check your measure there might be some issue with percentage otherwise share sample data

[neodghale205889]

Thanks for this! However, when I do that, it seems that the results on my graph are not accurate:

I have applied the filter but it is still populating incorrect results. The majority of these lines are incorrect.

[bhanu_gautam]

@neodghale205889 , Since you have two measures than you can create a new measure from combination of both of them and use it in filter of visual

%ofGrade1and2 =
[%ofGrade1] + [%ofGrade2]

Add the Combined Measure to the Visual:

Add the combined measure %ofGrade1and2 to your visual.
Apply a Filter to the Visual:

Click on the visual to select it.
In the Filters pane, drag the %ofGrade1and2 measure to the Filters on this visual section.
Set the filter condition to show values where %ofGrade1and2 is less than 0.5 (50%).

[neodghale205889]

So i am analyzing grades of multiple items. There are grades 1,2,3,4,5,6.

I have two measures that find that %of grade 1 and 2. They both look identical to this formula, just grade two changes to pull 2 instead of 1:

%ofGrade1 =

VAR FilteredRows =

FILTER(

    'PRODUCTION- Results',

    CONTAINSSTRING(

        'PRODUCTION- Results'[Grade],

        "1"

    )

)

VAR Sumof1 =

SUMX(

FilteredRows,

'PRODUCTION- Results'[Total Weight]

)

VAR TotalLbs=

CALCULATE(

    SUM('PRODUCTION- Results'[Total Weight]),

    ALL('PRODUCTION- Results'[Grade])

)

RETURN

CALCULATE(

DIVIDE(

Sumof1,

TotalLbs

)

)

I then would like to either create another meausre, or somehow filter on a visual and basically say, if Grade 1+Grade2 added together are less than 50% populate the resulte, if it is more than 50% do not populate the result on my visual.

[bhanu_gautam]

@neodghale205889 , It would be better if you provide more context