Display Only Data with no values at specific dates

[Koobal]

Hello,

I'm completely beginer to powerBI.

to resume I have imported and transform 2 CSV, one with :

-sp_creation_date

-sp_name

-vol_id

Other with

-vol_id

-vol_name

Relation is set for the vol_id between the 2 CSV.

Here is my problem : I want to display on my dashboard every vol that have no snapshot on a date range.

Can someone help me doing this ?

Thanks in advance,

Best regards

[johnt75 · Accepted solution]

You can create a measure like

Is Missing Snapshot =
VAR VolsWithSnapshot =
    VALUES ( 'Snapshot'[vol_id] )
VAR CurrentVol =
    SELECTEDVALUE ( 'Volume'[vol_id] )
RETURN
    IF ( NOT CurrentVol IN VolsWithSnapshot, 1 )

and then add this as a visual level filter to your table visual to only show when the value is 1.