Conceptual
Browse Instruct Curate

DISTINCTCOUNT vs. DISTINCTCOUNTNOBLANK in DAX

The concept pertains to aggregation functions within Data Analysis Expressions (DAX) that calculate the number of unique values in a dataset. The core distinction lies between `DISTINCTCOUNT`, which includes null or blank entries as single distinct entities, and `DISTINCTNONBLANK` (`ALLEXCEPT`-agnostic), which filters out blanks before counting. This theoretical framework is essential for accurately computing cardinality metrics to derive weighted averages over time periods where data sparsity exists.