Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
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!
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.
Whoops, forgot to attach.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |