Forum Discussion
Restrictive multiple selection
Hi, Anonymous ;
You could create a new table then create a flag measure.
1.create a new table as slicer
slicer = VALUES('Table'[cate])2.create a flag measure.
flag = IF( CALCULATE(DISTINCTCOUNT('Table'[cate]),FILTER(ALL('Table'),[ID]=MAX('Table'[ID])))=DISTINCTCOUNT(slicer[cate]),1,0)3.apply the flag measure into filter
The final output is shown below:
Not sure you understand your logic correctly? If not, please correct me and provide more information.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi, Anonymous ;
You could create a new table then create a flag measure.
1.create a new table as slicer
slicer = VALUES('Table'[cate])2.create a flag measure.
flag = IF( CALCULATE(DISTINCTCOUNT('Table'[cate]),FILTER(ALL('Table'),[ID]=MAX('Table'[ID])))=DISTINCTCOUNT(slicer[cate]),1,0)3.apply the flag measure into filter
The final output is shown below:
Not sure you understand your logic correctly? If not, please correct me and provide more information.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Dear v-yalanwu-msft ,
First of all, sorry for my late reply.
In fact, I tried to do it your way but still could not achieve my goal.
I wish I could share the pbix file, but this platform doesn't allow me somehow.
Please access my files (containing dummy data) through the link below: (as I cannot attach any here)
Thank you very much,