Value from unralted table filer on second table.

[MikeOxley]

I have two tables, one with sales data by day, with a running total.

At the moment I get excel file that has sales information in, I get another request from another source but its a single date, it is NOT and CANNOT be relational to the sales data.

Two tables

Slicers dont work as its not relational.

Result

I wnat the users date to populate two CARDS with the two figures, Sales and total sales

[MikeOxley]

Thank you, I am very new at this - I was googling for weeks on how to select like in SQL and just dispaly the numbers (select sales from sales where date = 3 june 23) type uery but this is great, I never ask but this was frustrating. Will do a cource soon on Power BI and the new MS Fabric.

[MarkLaf · Accepted solution]

You could add a calculated column to your sales day by day table, like

SlicerCol =
IF( Sales[Data Date:] = MIN( SingleDate[DataDate] ), "The Date", "Not The Date" )

Or you can add a filter to applicable measures, like

Sales_TheDate = 
CALCULATE(
  SUM( Sales[Sales] ),
  KEEPFILTERS( TREATAS( VALUES( SingleDate[DataDate] ), Sales[Data Date:] ) )
)