Forum Discussion
Parvez933
Helper I
3 years agoSelected but also display all
Hi, We are trying to create a table and slicer which shows the below information in the form of 1 entry per selection: Company Package A 1.Bronze A 2.Silver AA 1.Bronze ...
- Anonymous3 years ago
Hi Parvez933 ,
- You need to create table to put the “Package” into the table, then use it as the slicer option, the code is as follows:
Table 2 = SUMMARIZE('Table','Table'[Package])
Then create a 1:N relationship between the tables
2. Create a new measure, and input the following code, and put the measure to the visual filter, set the condition that , the measure equal to 1
Measure = IF(ISFILTERED('Table 2'[Package]),IF(CALCULATE(COUNTA('Table'[Company]),'Table'[Company]=SELECTEDVALUE('Table'[Company]),ALL('Table'))=1,1,0),1)
The related Output
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Xinru Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Parvez933
Helper I
3 years agoHi @Xinru Zhu,
This is the expectation and we have achieved it. Thank You for your help.