Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!See when key Fabric features will launch and what’s already live, all in one place and always up to date. Explore the new Fabric roadmap
Hi @AtchayaP ,
Here are the steps you can follow:
1. Select three columns in Power Query – Unpivot Columns.
Result:
2. Use Enter data to create data.
3. Create measure.
Measure =
var _select=SELECTEDVALUE('Slicer_table'[Slicer])
return
IF(
_select ="Territory2",
SUMX(FILTER(ALL('Table'),'Table'[Attribute]="Territory2"),[Value]),SUMX(FILTER(ALL('Table'),'Table'[Attribute]=MAX('Table'[Attribute])),[Value]))
4. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @AtchayaP ,
Here are the steps you can follow:
1. Select three columns in Power Query – Unpivot Columns.
Result:
2. Use Enter data to create data.
3. Create measure.
Measure =
var _select=SELECTEDVALUE('Slicer_table'[Slicer])
return
IF(
_select ="Territory2",
SUMX(FILTER(ALL('Table'),'Table'[Attribute]="Territory2"),[Value]),SUMX(FILTER(ALL('Table'),'Table'[Attribute]=MAX('Table'[Attribute])),[Value]))
4. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
User | Count |
---|---|
88 | |
74 | |
69 | |
59 | |
56 |
User | Count |
---|---|
40 | |
38 | |
34 | |
32 | |
28 |