Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
MikeOxley
Frequent Visitor

Value from unralted table filer on second table.

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 tablesTwo tables

 

Slicers dont work as its not relational.

 

ResultResult

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

 

 

1 ACCEPTED SOLUTION
MarkLaf
Solution Sage
Solution Sage

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:] ) )
)

 

View solution in original post

2 REPLIES 2
MikeOxley
Frequent Visitor

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
Solution Sage
Solution Sage

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:] ) )
)

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.