cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bangerasid
Helper I
Helper I

Slicer not getting applied to measure in column!

Hi Experts,

 

Scenario:

 

Sample Data:

bangerasid_1-1652807060087.png

 

Data Model : The relationships are one to many (filtering : single)

bangerasid_2-1652807100815.png

 

Sample report:

 

bangerasid_3-1652807154626.png

-------------------------------------------------------------------------------------------

Student Count is a calculated field which shows 0 against week where student was not present:
                     IF(distinctcount[student] <> 1, 0, 1)

 

Ideally, on clicking the Area Slicer (blue bars), the student under it should show up, which is happening until I include the Stundent Count measure in the table. The slicer is not getting applied to the measure.
Meaning, it is showing all the students irrespective of the value clicked on Area Slicer.

 

Could someone please comment how to make the slicer applicable to the measure?

 

Just to note, the final output will show just the absent records:

bangerasid_4-1652807596003.png

 

Any help would be appreciated.

 

 

8 REPLIES 8
Whitewater100
Super User
Super User

Hi:

I received your message. How does this look? Ibuilt a model that should handle any reporting needs...so far!

https://drive.google.com/file/d/1uMw7CLj6pJnR-z0l8ZWWOigaIWm3lVEt/view?usp=sharing 

 

Whitewater100_0-1652823336947.png

 

Thanks for responding.

I tried the same approach, but still no success.
When I click on the location slicer, All the location values in the table change to the selected value:

Eg:

bangerasid_0-1652904718055.png

Whenever I click on any area in slicer, the corresponding value against each student changes to that value.
Also to note, each student has just one area.

420 belongs to Area 1
500 belongs to Area 2.



So after clicking Area 1 - slicer, only student 420 should show up along with the weeks was absent.

 



Hi:

I see. I took out the area slicer as it is duplicating the student slicer.

https://drive.google.com/file/d/1uMw7CLj6pJnR-z0l8ZWWOigaIWm3lVEt/view?usp=sharing 

 

Whitewater100_1-1652909839280.png

 

Hi:

I checked and Student 420 was absent week 19. If we exclude that week, then just 500 is absent. But if you include 3 weeks then both students have absenses. 

Student 420 Absent Week19

Student 500 Absent Weeks 19-21

 

Does this make sense? Thanks..

 

It seems to be working. Do you have the example file to check?

 

Whitewater100_0-1652908509171.png

https://drive.google.com/file/d/1uMw7CLj6pJnR-z0l8ZWWOigaIWm3lVEt/view?usp=sharing

 

bangerasid
Helper I
Helper I

@tamerj1 

 

I am afraid I wont be able to share the dataset due to restrictions. 

To summarize the issue, Area filter is not getting applied to the table once the measure Student Count is included.

 

Confused about whats going wrong!😶

tamerj1
Super User
Super User

Hi @bangerasid 

add "Stdunet" as a measure:

Student Measure = SELECTEDVALUE ( TableName[Student] )

remove the "Student" column from the table visual

Hi @tamerj1 ,

 

Thanks for responding.
I tried the approach and apparently its returning blank values,

bangerasid_0-1652809475083.png

 

 

 

@bangerasid 

I need to work on a sample file. Any chance you can share?

Helpful resources

Announcements
Carousel_PBI_Wave1

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.

Power BI Summit Carousel 2

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!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors