cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
azeemkhalipha
Regular Visitor

DAX error

1.JPG2.JPG3.JPG

 

 

 

I have used DAX code to use UNICHAR for showing Loss in financial data, but I am getting the above error. Please help (Note- I am using financial data by Power BI desktop)

 

 

@needhelp 

1 ACCEPTED SOLUTION
amitchandak
Super User IV
Super User IV

@azeemkhalipha , As I suggested above, I created it as a measure and that seems to be working. Please find the file attached after signature.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

6 REPLIES 6
amitchandak
Super User IV
Super User IV

@azeemkhalipha , As I suggested above, I created it as a measure and that seems to be working. Please find the file attached after signature.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

amitchandak
Super User IV
Super User IV

@azeemkhalipha ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

amitchandak
Super User IV
Super User IV

The "Enterprise" row is showing twice when I add the DAX function. I want it to be in one row only with "red" remark

PhilipTreacy
Super User III
Super User III

Hi @azeemkhalipha 

Download sample PBIX with this code and visual

As a Measure use this

 

Remark = 

VAR _Red = UNICHAR(128308)
VAR _Green = UNICHAR(128994)

RETURN
IF(MAX('Financials'[Profit]) <= 0 , _Red, _Green)

 

Capture.PNG

 

 

 

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors