Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |