Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 :
Can you help me on that point ?
Thanks in advance.
Luca
Solved! Go to Solution.
Hi , @Anonymous
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.
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.
Hi , @Anonymous
Here is a workaround , please refer to this demo.
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:
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.
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 ?
Hi , @Anonymous
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.
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.
Hi,
Could you please share the PBIX file. I am also facing same issue.
Could you please share the PBIX file.
Suman
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
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |