TOP 16 DAX QUERIES FOR CREATING MEASURES IN POWER BI

PRACTICE IN POWER BI 

• Measure = SUMX (ORDERS, ORDERS[UNITS]*RELATED(TABLES[MAKING TIME ( DAYS )])) 

• Measure = AVERAGE(ORDERS[DELIVERYTIME])

• Measure = AVERAGEX (Sheet2, Sheet2[DELIVERYTIME]+ORDERS[PROCESSTIME]) 

• Measure = COUNTBLANK(ORDERS[DELIVERYTIME])

• Measure = DISTINCTCOUNT(ORDERS[PROCESSTIME]) 

• Measure = DISTINCTCOUNTNOBLANK(ORDERS[DELIVERYTIME])

• Measure = CALCULATE(SUM(ORDERS[UNITS]),ORDERS[Product Name]="CCTV"|| ORDERS[Product Name]="FAN")

• Measure = CALCULATE(SUM(ORDERS[UNITS]),ORDERS[Product Name]="CCTV",ORDERS[UNITS]>50)

• Measure = CALCULATE(COUNT(ORDERS[UNITS]),ORDERS[DELIVERY DAYS]=1 && ORDERS[PROCESS DAYS]=1)

• MEASURE = FIRSTDATE(ORDERS[DATE]) 

• Measure = DATE(2009,7,8) 

• Measure = COMBINEVALUES(":","HELLO","WORLD","INDIA")

• MEASURE = CONCATENATE("Hello ", "World") 

• Measure = CONTAINS(ORDERS, orders[ORDER ID], 4, ORDERS[Product Name], "FAN")

• Measure = CONTAINS(ORDERS, orders[ORDER ID], 4) 

• Measure 2 = CONTAINSROW(TABLES,"TABLE 4","BLACK",2,"WOOD")

• Measure = SUMX (ORDERS, ORDERS[UNITS]*RELATED(TABLES[MAKING TIME ( DAYS )])) 

• Measure = AVERAGE(ORDERS[DELIVERYTIME])

• Measure = AVERAGEX (Sheet2, Sheet2[DELIVERYTIME]+ORDERS[PROCESSTIME]) 

• Measure = COUNTBLANK(ORDERS[DELIVERYTIME])

• Measure = DISTINCTCOUNT(ORDERS[PROCESSTIME]) 

• Measure = DISTINCTCOUNTNOBLANK(ORDERS[DELIVERYTIME])

• Measure = CALCULATE(SUM(ORDERS[UNITS]),ORDERS[Product Name]="CCTV"|| ORDERS[Product Name]="FAN")

• Measure = CALCULATE(SUM(ORDERS[UNITS]),ORDERS[Product Name]="CCTV",ORDERS[UNITS]>50)

• Measure = CALCULATE(COUNT(ORDERS[UNITS]),ORDERS[DELIVERY DAYS]=1 && ORDERS[PROCESS DAYS]=1)

• MEASURE = FIRSTDATE(ORDERS[DATE]) 

• Measure = DATE(2009,7,8) 

• Measure = COMBINEVALUES(":","HELLO","WORLD","INDIA")

• MEASURE = CONCATENATE("Hello ", "World") 

• Measure = CONTAINS(ORDERS, orders[ORDER ID], 4, ORDERS[Product Name], "FAN")

• Measure = CONTAINS(ORDERS, orders[ORDER ID], 4) 

• Measure = CONTAINSROW(TABLES,"TABLE 4","BLACK",2,"WOOD")