Qlik filter values into comma separated values

 

 

Replace(

Concat({<[Aggregation Level 1] = p([Aggregation Level 1])>} [Aggregation Level 1], ',')

,'Region','region_name') 

to use the list as values/column name in the expressions

$(=$(Aggregationlist))

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.

Power BI Measure - DAX query to count string values

 Total =

VAR Count1= [field1]

VAR Count2=[field2]

VAR T1= SWITCH(TRUE(), SELECTEDVALUE(dataset1[IsRequired])="Yes",Count1, SELECTEDVALUE(dataset1[IsRequired])="NA",Count2)

Return T1

Power BI DAX Measure to calculate value based on another column

IsValid = CALCULATE(DISTINCTCOUNT(Con[TId]), Con[Required]="Yes" && Con[TId]=BLANK())

Power BI to ignore or fitler certain values from the report using Calculated Column

 CountryCheck = IF((Dataset[Name]="ABC" && Dataset[Country]<> "Canada"),0,1)

more conditions can be added and apply filter CountryCheck !=0

Power BI URL formation dynamically

 URL = MAX('links'[ReportUrl]) & if(ISFILTERED(User[UserID]), "&UserID=" & SELECTEDVALUE(User[UserID]),"")

It help to form report URL with any field as filter in the new report that we can use.