cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper III

## Filter values which achieves/unachieves target in a matrix

Hi friends,

I have a matrix table which shows up the performance of region.

If region performance is greater than pass working day in a month, that region achieves target. Conversely, It unachieves target.

I created a table selection allowed the user to filter which region achieved/unachieved target in month.

I am unable to create a calculated column which shows achieve/unachieve because of complicated model.

It is possbile to create MEASURE to allow the users to filter regions achieved/unachieved  target?

Any help is highly apprecitated.

1 ACCEPTED SOLUTION
Community Champion

A workaround will be like this.

1- Create a measure with your criteria that will return Text Values.

``_Achive = IF([_Measure]>6 , "Achieve","Not Achieve")``

2- Create a Filter Table (disconnected) having 2 values("Achieve" & "Not Achieve") which will be used in Slicer

3- Create another measure to return True if the condition is met.

``````_Criteria =
Var a = [_Achive]
var b = SELECTEDVALUE('Filter'[Criteria],MAX('Filter'[Criteria]))
RETURN
//b
IF (HASONEVALUE('Filter'[Criteria]),IF(a=b,1,0),1)``````

4- Now at the Visual Level filter put this new measure and Filter out values when the condition is 1

5- Create a slicer and put Filter Table values in it. Do a selection and check if the results are the same as required.

Proud to be a Super User!

3 REPLIES 3
Community Champion

A workaround will be like this.

1- Create a measure with your criteria that will return Text Values.

``_Achive = IF([_Measure]>6 , "Achieve","Not Achieve")``

2- Create a Filter Table (disconnected) having 2 values("Achieve" & "Not Achieve") which will be used in Slicer

3- Create another measure to return True if the condition is met.

``````_Criteria =
Var a = [_Achive]
var b = SELECTEDVALUE('Filter'[Criteria],MAX('Filter'[Criteria]))
RETURN
//b
IF (HASONEVALUE('Filter'[Criteria]),IF(a=b,1,0),1)``````

4- Now at the Visual Level filter put this new measure and Filter out values when the condition is 1

5- Create a slicer and put Filter Table values in it. Do a selection and check if the results are the same as required.

Proud to be a Super User!

Helper III

OMG! @FarhanAhmed It is perfectly awesome!!

Thank you so much!

Super User

@tracytran91 , if you want filter based of measure then you have to use an independent table and do binning/bucketing

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

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

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

#### New forum boards available in Real-Time Intelligence.

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

Top Solution Authors
Top Kudoed Authors