Forum Discussion
sppt
2 years agoFrequent Visitor
Filter values that 'are not present'.
I hope I can describe the topic reasonably well. We have a cash register system that, in the case of discounts, does not flag the receipt itself, but only the receipt lines. So if we now fi...
Daniel29195
Community Champion
2 years agoSELECT [Receipt], [Turnover] FROM [Table1]
WHERE [Table1].[Receipt] IN (SELECT [Receipt] FROM [TableWithReceiptNoAndDiscountReasonColumn])
measure as follow :
var ds_1 = values(table1[receipt])
var ds_2 = values(TableWithReceiptNoAndDiscountReasonColumn[receipt]
var res =
intresect ( ds_1 , ds_2 )
return
switch( true() , tbl[rec] in res , 1 , blank() )
you can use this measure in the filter pane on the visual level. --> is = 1 . or not is blank() .
or you can instead of
return
switch( true() , tbl[rec] in res , 1 , blank() )
use :
calculate ( count( tbl[receipt) , keepfilters( res ) )
let me know if this helps .