Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
Solved! Go to Solution.
To report on things that are not there you need to use disconnected tables and/or crossjoins
Hi,
PBI file attached.
Hope this helps.
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.
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.
To report on things that are not there you need to use disconnected tables and/or crossjoins
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
101 | |
87 | |
73 | |
67 |
User | Count |
---|---|
116 | |
109 | |
94 | |
79 | |
72 |