CODEWITHSUNDEEP
powerbidaxpercentagemissing-data
George Sanchez
George Sanchez

Reputation: 27

DAX Ratio of missing values

I'm trying to find a DAX formula to calculate the percent of products that are not sold in all the regions.

The table that I'm using is the Sales table which has:

Thank you

Upvotes: 0

Views: 256

Answers (1)

Daryl Wenman-Bateson
Daryl Wenman-Bateson

Reputation: 3939

Create a calculated column to work out if distinct Territory count match's distinct Territory count per Product

    All Regions = 
    VAR Territory = CALCULATE(DISTINCTCOUNT(Sales[Territory]), All(Sales))

    VAR ProductTerritories = CALCULATE(DISTINCTCOUNT(Sales[Territory]), ALLEXCEPT(Sales, Sales[Product]))
RETURN 
    Territory = ProductTerritories

This will then return True or False against each Product

Product Sold in All Territories

Upvotes: 1

Related Questions