Forum Discussion
Slicer not affecting measure
Hello All,
I have a sample data of table below:
I want to create two measures:Assessment_1,Assessment_2.
Assessment 1 gives the values of assesment column based on selection in slicer1(PI).
Assessment 2 gives the values of assesment column based on selection in slicer2(PI).
I finlly want a table with LEVEL,NAME,ASSESSMENT1,ASSESMENT2 and Diff(Assessment1-Assessment2).
I crate separate measures for each,based on slicer..but the problem is the second measue gets affected by selection of slicer1 value.
TABLE1:
| LEVEL | NAME | PI | ASSESSMENT |
| L1 | aa | 1 | 10 |
| L1 | bb | 2 | 20 |
| L1 | cc | 3 | 50 |
| L2 | df | 1 | 12 |
| L2 | gg | 2 | 15 |
| L3 | hj | 1 | 15 |
| L3 | rr | 2 | 12 |
| L3 | ty | 3 | 50 |
My final result should be, for example if slicer 1 PI=2 and Slicer2 PI=3.
| LEVEL | Assesment_Slicer1(PI=2) | Assessment_Slicer2(PI=3) |
| L1 | 20 | 50 |
| L2 | 15 | null |
| L3 | 12 | 50 |
Any help?
Rather than using the PI column in the slicers, create 2 new tables like
Slicer 1 = ALLNOBLANKROW('Table'[PI]) Slicer 2 = ALLNOBLANKROW('Table'[PI])Don't link these to the main table, just use them on the slicers.
You could then create measures like
Assessment 1 = CALCULATE( SUM('Table'[Assessment]), TREATAS( VALUES('Slicer 1'[PI]), 'Table'[PI])) Assessment 2 = CALCULATE( SUM('Table'[Assessment]), TREATAS( VALUES('Slicer 2'[PI]), 'Table'[PI]))
2 Replies
Rather than using the PI column in the slicers, create 2 new tables like
Slicer 1 = ALLNOBLANKROW('Table'[PI]) Slicer 2 = ALLNOBLANKROW('Table'[PI])Don't link these to the main table, just use them on the slicers.
You could then create measures like
Assessment 1 = CALCULATE( SUM('Table'[Assessment]), TREATAS( VALUES('Slicer 1'[PI]), 'Table'[PI])) Assessment 2 = CALCULATE( SUM('Table'[Assessment]), TREATAS( VALUES('Slicer 2'[PI]), 'Table'[PI]))Works perfectly. One part to be added is, you also need to remove interaction between the slicers to get the correct values.
Thanks a lot!!
