cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Apply a slicer on a specific column in a table

Hi all,

 

I want that the slicer "Planning" filters only on the column "VERSION" of my table, the others must not be impact by the slicer : 

 

image.png

image.png

 

Can you help me on that point ?

 

Thanks in advance.

 

Luca 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Apply a slicer on a specific column in a table

Hi , @luca_borome 

Take a try this measure as below:

 

VERSION =
CALCULATE (
    SUM ( EDOC[FIC_Eval_Des_SolExpert_A] )
        + SUM ( EDOC[FIC_Eval_Build_SolExpert_B] );
    FILTER (
        EDOC;
        'EDOC'[Planning] IN DISTINCT ( 'SlicerTable'[Planning] )
            && ( EDOC[Macro statut] = "20-DESIGN"
            || EDOC[Macro statut] = "30-BUILD" )
    );
    USERELATIONSHIP ( 'Domain (Forecasts)'[Domain EDOC]; EDOC[Domain] )
)

 

If help ,here is another workaround.

Pbix attached

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

5 REPLIES 5
Highlighted
Super User IV
Super User IV

Re: Apply a slicer on a specific column in a table

You have to create all the other measures with all. If we try to use interactions and stop it, then we might not get the value to filter too



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

Highlighted
Super User IV
Super User IV

Re: Apply a slicer on a specific column in a table

Difficult to tell what is going on here or the best approach. You could use Edit Interactions to decouple the slicer from the table and then write a measure for Version that uses VALUES from your slicer. Or do the opposite and writes measures for everything else that use ALL. But, very difficult to tell which is best or if either will work. Suggest posting sample data and expected results.

---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Microsoft
Microsoft

Re: Apply a slicer on a specific column in a table

Hi , @luca_borome 

Here is a workaround , please refer  to this demo.

pbix attached

Try steps as  below:
1.Create a calculate table as the slicer

Fruit slicer = DISTINCT(Fruit[Fruit(Date)])

2.Create a measure to replace the field "Kind (version)"

Kind (Version) measure = 
IF (
    CALCULATE ( COUNTROWS ( 'Fruit slicer' ), ALLSELECTED ( 'Fruit slicer' ) )
        < CALCULATE ( COUNTROWS ( 'Fruit slicer' ), ALL ( 'Fruit slicer' ) ),
    IF (
        CALCULATE (
            COUNTROWS ( 'Fruit' ),
            'Fruit'[Fruit(Date)] IN DISTINCT ( 'Fruit slicer'[Fruit(Date)] )
        ) > 0,
        SELECTEDVALUE ( Fruit[Kind (Version)] ),
        ""
    ),
    MAX ( Fruit[Kind (Version)] )
)

 

3. It will show as below:

35.png

If I misunderstood ,please let me know.

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

Highlighted
Helper III
Helper III

Re: Apply a slicer on a specific column in a table

Hi @v-easonf-msft ,

 

Thanks for your answer, I think we are on the good way ! 

 

In fact VERSION is already a measure, can you help me to modify it ? 

 

VERSION = CALCULATE(sum(EDOC[FIC_Eval_Des_SolExpert_A])+sum(EDOC[FIC_Eval_Build_SolExpert_B]);FILTER(EDOC;EDOC[Macro statut]="20-DESIGN" || EDOC[Macro statut]="30-BUILD");USERELATIONSHIP('Domain (Forecasts)'[Domain EDOC];EDOC[Domain]))
 
Thanks 
Highlighted
Microsoft
Microsoft

Re: Apply a slicer on a specific column in a table

Hi , @luca_borome 

Take a try this measure as below:

 

VERSION =
CALCULATE (
    SUM ( EDOC[FIC_Eval_Des_SolExpert_A] )
        + SUM ( EDOC[FIC_Eval_Build_SolExpert_B] );
    FILTER (
        EDOC;
        'EDOC'[Planning] IN DISTINCT ( 'SlicerTable'[Planning] )
            && ( EDOC[Macro statut] = "20-DESIGN"
            || EDOC[Macro statut] = "30-BUILD" )
    );
    USERELATIONSHIP ( 'Domain (Forecasts)'[Domain EDOC]; EDOC[Domain] )
)

 

If help ,here is another workaround.

Pbix attached

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors