Forum Discussion

vitinho's avatar
vitinho
Icon for Helper I rankHelper I
9 years ago

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...
Need Help
vitinho's avatar
vitinho
Icon for Helper I rankHelper I
9 years ago

Do you know a way to extract a sample from a Analytics Query?

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

vitinho

 

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,