Forum Discussion
Dax in Power Bi Duplicate issues
Hi Karolina411
It seems that you are doing the union of 16 tables, and then there are duplicate measure types, which seems to be caused by different results of [DAWNumerator] or [DAWDenominator]. However, since DAX is too complicated and involves too much data and other measures, I cannot clearly know the problem based on DAX and screenshots. Could you please provide your files or sample data? How to provide sample data in the Power BI Forum - Microsoft Fabric Community Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.
In addition, I need to confirm with you that you said "transfer a report from report builder to Power", but from your screenshot, it seems that it is not the interface of report builder. Could you please explain the meaning of this sentence? Do you need to publish the report to Power BI Service?
Thank you for your time and efforts in advance.
Best Regards,
Yulia Xu
https://drive.google.com/drive/folders/1f2dNUj2ZOOsdVaW3B2TXNAFVuO_ALEGF?usp=sharing
Here there are 2 files-an .rdl (correct numbers) and a .pbix (incorrect numbers). When you slice by PCPLocation some are split up for some reason.
My Dax Queries are all different , too. Very strange.