Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
v-qiuyu-msft
Community Support

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 

philippfrenzel
Frequent Visitor

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

 

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

v-qiuyu-msft
Community Support

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