cancel
Showing results for
Did you mean:
Frequent Visitor

## 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?

1 ACCEPTED SOLUTION
Super User

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 2
Frequent Visitor

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!!

Super User

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]))``````

Announcements

#### 2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

#### Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

#### 2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors