Display & Count number of individuals with non-actions?

[SevsBo]

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)

[lbendlin · Accepted solution]

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

[Ashish_Mathur · Accepted solution]

Hi,

PBI file attached.

Hope this helps.

[Anonymous · Accepted solution]

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.

[Ashish_Mathur · Accepted solution]

Hi,

PBI file attached.

Hope this helps.

[lbendlin · Accepted solution]

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