need some dax or logic

[PowerBIBeginer]

Hi All,

Every month I used to download one excel data from one of the work tracker tool. This excel download i took every monday and the same excel sheet I upload in power bi in table. Now on that table I use below dax to get random records. Reason for random records is b'coz to perform quality checks on those selected random records.

Dax-

qc output = SAMPLE(COUNT('Main raw'[Associate])/5,'Main raw',[Associate])

this output is in table format.

Now my problem is, when I do download from work tracker for next mondays, definatly that ID's which are generated from above dax is also there in next monday raw dump. Let me give example..

for 14th Jan download there were 144 records, based on above dax it provided me 22 records for qc.

Now today when i took raw dump, the total raw dump is 339 from 1st Jan and it also includes above 22 records.

I want to exclude those 22 records and provide me output. Is there any way to build this? 

In "model view" I cant see the calculated table created, otherwise I can map those ID column and lookup dax could possible to apply. But table I cant see in model view..

[danextian]

Hi @PowerBIBeginer 

Power BI reads data directly from the source and does not store previously generated random values. Those 22 records will always reappear after each refresh if they are present in the source. The records that need to be excluded must be tracked or stored somewhere and then fed back into the model as a reference for exclusion.

[PowerBIBeginer]

Could you help me then how do I get those excluded when every time I do raw dump refresh?

[danextian]

Do you already have a separate data source that tracks those records already included in the prior quality check? Without that, there's no way to exclude them.