Showing total in a table

[Anonymous]

Dear all, good morning. 

I have the below table and would like to create a chart that would showcase the total of cargoes by day.

Cargo ID	Entered Day	Released Date
A	01/01/2021	03/01/2021
B	02/01/2021	04/01/2021
C	01/01/2021	02/01/2021

I managed to create it using the below with @speedramps  help

Cargoes in Warehouse =

VAR mydate = SELECTEDVALUE('Calendar'[Date])

var min_date = CALCULATE(MIN('Calendar'[Date]))

Var max_date = CALCULATE(MAX('Calendar'[Date]))

VAR validrows = FILTER(Commodity_List, Commodity_List[Warehouse Receipt Date] <= min_date && Commodity_List[Release Out Date] >= max_date)

RETURN

COUNTROWS(validrows)

But now I need to have a table/matrix containing all cargo ID for the month, so if I click on a specific month it will show all cargoes for that month as a list / table.

Could anyone help me?

@speedramps 

[speedramps · Accepted solution]

Hi again Pedro !

I have updated the example 

Click here to download the example 

There is a By Mate page and By Month page.

Click on day or month on the graph and all the valid cargo details will be displayed in the bottom visual.

This is done by adding the Valid Cargos field in the filter panel

See attached screen print

please click thumbs up and accept solution, thank you.

[Anonymous]

Incremental refresh to build data - snapshots 

The man and the myth, thanks and solution accepted 🙂

[speedramps]

Thak you Pedro. Well done !

[speedramps]

As explained before, this measure will handle by day, month with a calendar

Valid cargos =

var min_date = MIN ( 'Calendar'[Date] )

Var max_date = MAX ( 'Calendar'[Date] )

VAR validrows = FILTER ( Commodity_List , Commodity_List[Entered Day] <= max_date && Commodity_List[Released Date] >= min_date )

RETURN

COUNTROWS ( validrows )

Click here to download an example 

Click here to learn how to build a calendar 

[Anonymous]

@speedramps 

But how can I see which cargoes are being considered for each date? I would like to click on the chart and show me on a table what are the ones considered (like cargo A,B for day2)