Forum Discussion
Optimizing Measures to avoid Out of memory errors
I need help in understanding how to optimize some measures and have a few questions. My system configuration is : OS : Windows 10 (64 bit) Memory : 8 GB RAM MSOffice : Office 2016 Pro (64 bit)...
can you just share the Top20 rows from your data table and the expected output for the shared sample?
here is a post on how to share:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
regarding the measures:
does UniqueCount give you correct results? for the first date of appearance SUMMARIZE by Char with ALL and MIN on date should work
Hi @stacu,
I have mailed you the sample testdata.xlsx file yesterday. It has the 2 tables added to data model ( links removed).
As you will see, there is a many-to-many relationship between country and category as well as brand owner. Also, you will see, some characteristic description are common across categories. I think this is the reason why uniques are not getting identified correctly. How do we tackle this M2M?
I have mailed you the sample testdata.xlsx file yesterday. It has the 2 tables added to data model ( links removed).
As you will see, there is a many-to-many relationship between country and category as well as brand owner. Also, you will see, some characteristic description are common across categories. I think this is the reason why uniques are not getting identified correctly. How do we tackle this M2M?