cancel
Showing results for 
Search instead for 
Did you mean: 

Issue with Comment in Measure

Following Szenario,

 

I have a dax formula like

 

No. of Opps YTD =
CALCULATE(
  DISTINCTCOUNT('OpportunityProduct'[OpportunityId]);
  FILTER('Date';'Date'[CYTD] IN {1})
 // this is my comment
)
 
which works fine on the PowerBI Desktop, if I publish this to the PowerBI Service, all charts and elements using this formula will "break".
 
To solve it, you just have to remove the comment from the DAX Formula...!
 
Should be fine, if online and local would behave the same way...
 
Cheers Philipp
Status: New
Comments
Moderator

Hi @philippfrenzel

 

I tested on my side but not able to reproduce the issue. Please test with our report on your side to see if the same issue occurs. 

 

q2.PNG

 

Best Regards,
Qiuyun Yu 

Frequent Visitor

I tried with your sample, and it doesn't work either Smiley Sad

 

2019-05-17 07_30_12-Solution1 - Microsoft SQL Server Management Studio.png

So as you can see, i recieve a lot of error messages, including a warning... locally it works...

How can I help you to debug better?

Thanks for your help

 

Philipp

Moderator

Hi @philippfrenzel

 

Please try with different browsers. If the same issue still occurs, I guess the issue might be related to your cluster wabi-europe-north-b, I would suggest you create a support ticket to let engineers look into the issue on your side. 

 

Support Ticket.gif

 

Best Regards,
Qiuyun Yu