Dynamic label based on custom measure

[IvanMislav]

Hi, i have a simple data model. Something like company name, income, expenses.

I created a custom measure Balance = income - expenses.

What I want to do is create a dynamic lable: 

•  if balance < 0 = "Negative"
• if balance >= 0 = "Positive"

Finally, I want to have a number of companies by type.

I wrote a measure "Number of negative companies" = CALCULATE(DISTINCTCOUNT(data[CompanyName]);Balance<0) and I get an error saying "A function 'CALCULATE' has been used in a True/False expression that is used as a table filter expression. This is not allowed."

What am I doing wrong?

Thank you!

[Greg_Deckler]

You could do this:

Label = 
SWITCH(TRUE(),
    [Balance]<0,"negative",
    [Balance]>0,"positive",
    "zero"
)

NegativeCount = 
VAR __table = SUMMARIZECOLUMNS('Table19'[Company],'table19',"__balance",[Balance])
RETURN
COUNTX(FILTER(__table,[__balance]<0),[Company])

See attached Table 19, Page 11

[IvanMislav]

Hi, Greg!

Thank you for your answer. I can't find the attached table.

[Greg_Deckler]

Whoops, forgot to attach.

[IvanMislav]

Thanks, I can see the file now.

This works when there are unique values for companies. In my table company name values are not unique.

[Greg_Deckler]

Works for me. See updated attachment. Not sure why you would get different results. Perhaps share your sample data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490