Skip to main content
cancel
Showing results for 
Search instead 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

Reply
NicolasF26
Regular Visitor

Mesure as a filter

Hello Everyone,

 

I can't manage to use a measure as a classic filter for a visual.

I use this measure to find the first unique value in the column named "CT"

 

FIRST_CT = INDEX(1,DISTINCT(Tableau1[CT]),ORDERBY(Tableau1[CT]))
 
and I want to filter another column (Named "Designation"), and get a table with list of values; values that have as a "CT" column occurrence the result of the measure (which in this case is "CT0161").
 
I reckon it's about values format maybe, but I don't find a way to easily use this measure as a filter, as I could do with any other occurrence in other column
 
Thanks for your help
Best
Nicolas
 
7 REPLIES 7
CharbelArmaleh
Resolver II
Resolver II

Hello

 

A measure cannot be used as a filter, only calculated column can do

 

 

Did I answered your question? Please mark my post as solution!

 

 

HELLO, 

Okay but I don't understand what the column should calculate to be able to refer to the first occurance filtred 

Idrissshatila
Super User
Super User

Hello @NicolasF26 ,

 

If you want to use it as a filter, you should make it as a calculated column and then put this column in the slicer.

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Could it be done by a LOOKUP Dax but to obtain a list of values instead of the first one ?

@NicolasF26 
No, it should be a calculated column so you could view it.

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Okay but I don't understand what the column should calculate to be able to refer to the first occurance filtred 

Thank @Idrissshatila for you reply, why do I have to make a calculated column, to create an dynamique Index ?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

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.

Top Solution Authors