Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have a report that has 2 columns, one is a Number, the 2nd is a line of business. I created a slicer table that has 4 line of business names, and i created a measure based on another post here in Powerbi to filter for that slicer line of business in the report table. The issue i am having is that 2 of the names are close to the same accept 1 has an additional letter. Example: SET and SETF, how can i filter just on what choose? So if i choose SET, it won't find the SETF also.
This is the measure command:
Solved! Go to Solution.
Hi @scottm0690 ,
You can just creata replationship between these two tables based on field [Impacted LOB] and [LOB].
Or add one condition befor this IF in your measure.
add =
IF (
LEN ( SELECTEDVALUE ( 'Table'[LOB] ) ),
LEN ( SELECTEDVALUE ( 'Changes Opened - By LOB'[Impacted LOB] ) ),
[measure]
)
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @scottm0690 ,
You can just creata replationship between these two tables based on field [Impacted LOB] and [LOB].
Or add one condition befor this IF in your measure.
add =
IF (
LEN ( SELECTEDVALUE ( 'Table'[LOB] ) ),
LEN ( SELECTEDVALUE ( 'Changes Opened - By LOB'[Impacted LOB] ) ),
[measure]
)
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@scottm0690 ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
need to where is word lying so can we have exact match or not
My slicer is a table i built
When i choose SET, it shows SET and SETF, i just want SET
Thanks, hope this helps.
User | Count |
---|---|
121 | |
72 | |
71 | |
57 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
65 | |
55 |