chiclet slicer to keep drill through selection for more than one page

Here is the video to update /keep drill through selection on for as many as pages we want. 

https://www.youtube.com/watch?v=uq0FozPBidE&t=273s

Date format with time zone in Power BI

Choose the date field and enter below expression in the dropdown. it will accept and change the format accordingly. 

my sample data is in EST and no hours difference and I just hardcoded EST at the end. conversion needed if the data tracked in the different time zone. 

mm/dd/yyyy hh:mm:ss AM/PM "EST"

Power BI slicer or filters are not working in another page

 

Sync filters by choosing a filter in any page and update as needed. 

Power BI Rank & Dense Rank

 Rank = RANKX(all(Sheet1),Sheet1[Column1],,DESC)

DenseRank = RANKX(all(Sheet1),Sheet1[Column1],,DESC,Dense)

Power BI DAX measure to lookup value from other table without Merging two tables

 Lookup_Name = LOOKUPVALUE(details[Name],details[SId],Dataset1[SId])

Here we are creating this measure under Dataset1 to pickup Name field from details table.

Note: If we have more than one matching row for the same ID, either one or second row value will be populated.