The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi @ERing
The underlying cause of this is that DAX is not case-sensitive in Power BI.
In practice this means:
These two articles cover the topic pretty well:
In your case, can you check whether multiple capitalizations of the same value were actually loaded to the dataset? I would suspect that either "Luxury" or "LUXURY" but not both would actually appear in the column after loading the table.
One suggestion in the 2nd article is to append one or more zero-width spaces (such as UNICHAR(8203) ) to certain text values in order to differentiate them without altering the appearance. You could use some method to index the variations of "equivalent" strings, so that the 1st is left unchanged, the the 2nd has one zero-width space added, and so on.
It might be best to solve this in the data source rather than Power Query.
Regards
User | Count |
---|---|
26 | |
10 | |
8 | |
6 | |
6 |
User | Count |
---|---|
31 | |
11 | |
10 | |
10 | |
9 |