Hello,
We are trying to reproduce the following scenario with no sucess:
Thank you in advance and regards,
Adri.
Solved! Go to Solution.
Hi @asaemart,
I try to reproduce your scenario by my sample table below.
I create a new table including flag1 by clicking "New Table" under Modeling on Home page.
Create two measures using the following formula.
ISSELECTED = IF(ISFILTERED(Table3[flag]), VALUES(Table3[flag]),BLANK()) Sales-new = IF(ISBLANK(Table3[ISSELECTED]),CALCULATE(SUM(Table2[sales]),FILTER(Table2,Table2[flag]="flag0")),CALCULATE(SUM(Table2[sales]),FILTER(Table2,Table2[flag]="flag1")))
Create a slicer including flag1, create a table visual shows the information, set the visual filter as the highlighted red line.
Please see the expected result. I shows the flag in table visual, so that you can see it directly. When we not select "flag1" it display all information for "flag0", otherwise, we select "flag0" it display all information for "flag1".
Please download the attachments to test.
Thanks,
Angelia
Hi @asaemart,
I try to reproduce your scenario by my sample table below.
I create a new table including flag1 by clicking "New Table" under Modeling on Home page.
Create two measures using the following formula.
ISSELECTED = IF(ISFILTERED(Table3[flag]), VALUES(Table3[flag]),BLANK()) Sales-new = IF(ISBLANK(Table3[ISSELECTED]),CALCULATE(SUM(Table2[sales]),FILTER(Table2,Table2[flag]="flag0")),CALCULATE(SUM(Table2[sales]),FILTER(Table2,Table2[flag]="flag1")))
Create a slicer including flag1, create a table visual shows the information, set the visual filter as the highlighted red line.
Please see the expected result. I shows the flag in table visual, so that you can see it directly. When we not select "flag1" it display all information for "flag0", otherwise, we select "flag0" it display all information for "flag1".
Please download the attachments to test.
Thanks,
Angelia
User | Count |
---|---|
136 | |
59 | |
56 | |
55 | |
47 |
User | Count |
---|---|
128 | |
76 | |
55 | |
54 | |
51 |