Blank data if one category of sales accounts for 100% of sales in a month

[nimp_kp]

Hi

As the title says, I'm trying to create a measure that blanks out all sales data in a month if only one product category has 100% of the sales. Dropbox link with sample file at the bottom.

In the below picture, all sales in month 1 is vegetable only, so i want month 1 to not show any data in the chart

Month 2 is fine, as there are sales across multiple categories.

Any help is appreciated.

Sample pbix included:

https://www.dropbox.com/s/vsqixjb2q7zy4cd/Sample.pbix?dl=0

[PaulOlding · Accepted solution]

Here's a measure that will check how many categories there are and only return the amount when there's more than 1.

Amount measure =

VAR _NumCategories =

CALCULATE(

COUNTROWS(VALUES(Ark1[Category])),

REMOVEFILTERS(Ark1[Category])

)

VAR _Result =

IF (_NumCategories > 1,

SUM(Ark1[Amount]),

BLANK()

)

RETURN

_Result