This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more
Hai Guys Need help on this.
Requirement
I Have a Year slicer and a group slicer( Two slicers) year slicer are have the different years from 2018 to 2022
In the target table, the year column only has 2022, and different groups like this
| Group | Year | Target |
| India | 2022 | 3 |
| Japan | 2022 | 3 |
| Russia | 2022 | 3 |
| Ukraine | 2022 | 3 |
| UK | 2022 | 2 |
| FRANCE | 2022 | 3 |
One condition > My manager wants to see if he doesn't select any filter(slicer) he wants to see a static value "10" otherwise that particular group value.
2nd Condition > If he directly selects 2022 or any year without group slicer he wants to see the static value "0 ".
But He wants to see the actual target value when he selects that particular year with a particular group only
Please help with this.
Target based on a condition: =
IF (
HASONEVALUE ( Data[Group ] ),
SWITCH (
TRUE (),
ISFILTERED ( 'Group'[Group ] ) && ISFILTERED ( 'Year'[Year] ), SUM ( Data[Target] ),
NOT ISFILTERED ( 'Group'[Group ] ) && ISFILTERED ( 'Year'[Year] ), 0,
10
)
)
Hai Jihwan Kim Thanks For the Solution.
But the requirement is something Different I will show you with mock data.
| Target Table | ||
| Group | Year | Target |
| India | 2022 | 3 |
| Japan | 2022 | 3 |
| Russia | 2022 | 3 |
| Ukraine | 2022 | 3 |
| UK | 2022 | 2 |
| FRANCE | 2022 | 3 |
Above attached is my target table.
And Below i am attaching requirement please help me
Thanks
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 23 | |
| 22 | |
| 14 | |
| 14 | |
| 13 |
| User | Count |
|---|---|
| 47 | |
| 39 | |
| 24 | |
| 22 | |
| 20 |