Forum Discussion
Excluding results from table
You could create a column in your dataset called CombinedKay, which is just the Reference and MovementKey combined:
Create a new measure called DuplicateCount. This will get the count over all time for the CombinedKeyCombo. You may have to change ALL to ALLSELECTED if you are using a slicer on the SnapshotDate:
DuplicateCount = CALCULATE(COUNT(Sheet1[CombindedKey]), all(Sheet1[SnapshotDate]))
Then, in your grid on the report, add a visual filter where DuplicateCount = 1:
All records:
Filtered Records:
You could create a column in your dataset called CombinedKay, which is just the Reference and MovementKey combined:
Create a new measure called DuplicateCount. This will get the count over all time for the CombinedKeyCombo. You may have to change ALL to ALLSELECTED if you are using a slicer on the SnapshotDate:
DuplicateCount = CALCULATE(COUNT(Sheet1[CombindedKey]), all(Sheet1[SnapshotDate]))
Then, in your grid on the report, add a visual filter where DuplicateCount = 1:
All records:
Filtered Records:
hi olesojg
My count does not work, i've tried ALLSELECTED and ALL See below
Hi Sir_night,
Sorry for my misunderstanding previously. :smileylol:
Based on my test, if you use ALL(Table1[SnapshotDate]) instead of All(Table1[SnapshotDate].[Date]) in your formula then the measure should work as expected. :smileyhappy:
DuplicateCount = CALCULATE(COUNT(Table1[CombinedKey]), ALL(Table1[SnapshotDate]))
Regards
still not working
