cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper III

## Display & Count number of individuals with non-actions?

Say I have a list of people that did certain interactions over a year. The table might look like this:

 DATE NAME ACTION 1 ACTION 2 January Jim Yes Yes January Alice Yes February Bill Yes March Jim Yes March Freddy Yes

If I want to see who took actions in March and February, I can easily do that, but is there a way to build a visual in Power BI that shows who hasn't taken any action in that time frame? A list of non-action takers, if you will? (in this case the only result should be Alice)

3 ACCEPTED SOLUTIONS
Super User

To report on things that are not there you need to use disconnected tables and/or crossjoins

Super User

Hi,

PBI file attached.

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Community Support

Hi @SevsBo

Thanks for the reply from @lbendlin  and @Ashish_Mathur , please allow me to provide another method:

1. Enter a new table as the slicer where the index column serves to sort the Date column.

no relationship between two tables

2. Create a measure as follows

``````noactionname =
VAR _count = CALCULATE(COUNT('Table'[NAME]), FILTER(ALLEXCEPT('Table', 'Table'[NAME]), 'Table'[DATE] IN VALUES('Date'[DATE])))
VAR _name = CALCULATE(MAX([NAME]), FILTER('Table', _count = BLANK()))
RETURN
IF(MAX([NAME]) = _name, 1, 0)``````

3. Put the measure into the filter so that the visual only shows data where the measure is equal to 1.

Result:

Best Regards,
Yulia Xu

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

3 REPLIES 3
Community Support

Hi @SevsBo

Thanks for the reply from @lbendlin  and @Ashish_Mathur , please allow me to provide another method:

1. Enter a new table as the slicer where the index column serves to sort the Date column.

no relationship between two tables

2. Create a measure as follows

``````noactionname =
VAR _count = CALCULATE(COUNT('Table'[NAME]), FILTER(ALLEXCEPT('Table', 'Table'[NAME]), 'Table'[DATE] IN VALUES('Date'[DATE])))
VAR _name = CALCULATE(MAX([NAME]), FILTER('Table', _count = BLANK()))
RETURN
IF(MAX([NAME]) = _name, 1, 0)``````

3. Put the measure into the filter so that the visual only shows data where the measure is equal to 1.

Result:

Best Regards,
Yulia Xu

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

Super User

Hi,

PBI file attached.

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Super User

To report on things that are not there you need to use disconnected tables and/or crossjoins

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors