Forum Discussion
doubled sum valeus
Hello, I have two analytics extractions that are linked by the key "Source_Medium_Campaign" and are grouped in categories by the same fact table. With this relation I'm able to calculate the sum of...
Do you know a way to extract a sample from a Analytics Query?
Using LOWER() within EXACT() should be no problem. I can't find any syntax issue in your measure. You can change the filter expression into:
FILTER(Table1, Table1[Date]=Table2[Date] && Table1[Can_n1&n2]=Table2[Can_n1&n2] && LOWER(Table1[IDTudepara])=LOWER(Table2[IDTudepara]) )
If the issue still persists, please share some sample data.
Regards,
The issue still persists, how can I send some sample data?
Make sure there is no leading or trailing white space, which would appear as a unique record regardless of lower/uppercase.
