Project

DAX Measure for Quantity Summary of Item Groups Starting with "C"

This code creates a DAX Measure using SUMX, FILTER, and LEFT functions to calculate the total quantity for 'item groups' that start with the letter "C" in a table. It provides an explanation of the DAX functions used and suggests using the Measure

Empty image or helper icon

DAX Measure for Quantity Summary of Item Groups Starting with "C"

Description

This code creates a DAX Measure using SUMX, FILTER, and LEFT functions to calculate the total quantity for 'item groups' that start with the letter "C" in a table. It provides an explanation of the DAX functions used and suggests using the Measure in report visuals to showcase the total quantity for 'C' item groups, encouraging further learning of DAX with Enterprise DNA courses.

Content