cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Filter only parts of a dataset

Hello I am Trying to make a report that will show employees in different business areas with the amount of Time they have been absent. I have a table that looks like this. 

 

Empl./Appl.NameDate    NumberOrg. UnitBusiness Area
Alan12/21/2020850541520Training
Alan12/22/2020850541520Training
Alan12/23/2020850541520Training
Francis7/12/20210.2350644332IT
Francis10/13/2021850644332IT
Jenn2/19/2021810013520HR
Jenn4/19/20214.710013520HR
Jenn7/20/2021850716112Quality

 

I would like to Filter on Business Area, but on my report I still need to see the total time for an employee; regardless of Business Area. For Example; If I filter for Quality, I would like to See Jenn as an employee with total time absent = 20.7 // instead of Jenn's time showing only 8.  (And I would Also see Jenn when I filter on HR also showing total absent time of 20.7). 

Link to Sample Table 

 

Thanks for the help!

1 REPLY 1
v-chenwuz-msft
Community Support
Community Support

Hi @Anonymous ,

 

Try this measure:

Total =
IF(
    ISBLANK( SELECTEDVALUE( 'Table'[Empl./Appl.Name] ) ),
    "Please select",
    CALCULATE(
        SUM( 'Table'[Number] ),
        ALLEXCEPT( 'Table', 'Table'[Empl./Appl.Name] )
    )
)

 

Result

vchenwuzmsft_0-1638410558748.png

 

I put my pbix file in the end you can refer.

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through June10th!

Power BI Dev Camp Session 22 without aka link and time 768x460.jpg

Check it Out!

Watch Session 22 Ted's Dev Camp along with past sessions!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!