Forum Discussion
Dynamic label based on custom measure
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 bala...
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
Hi, Greg!
Thank you for your answer. I can't find the attached table.