The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the July 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
112 | |
69 | |
48 | |
43 |
User | Count |
---|---|
189 | |
87 | |
77 | |
74 | |
60 |