Forum Discussion

Jaggana's avatar
Jaggana
Icon for Advocate I rankAdvocate I
10 months ago

Variables table using CALCULATETABLE with condition

Hello,   Here is my test source:  SalesTerritoryKey Country 1 United States 2 United States 3 United States 4 United States 5 United States 6 Canada 7 France 8 Germany 9 Australia 10 United Kingd...
Need Help
Jaggana's avatar
Jaggana
Icon for Advocate I rankAdvocate I
10 months ago

Hello Anonymous, 
As I can't upload a PBIX, CSV or TXT file, I've added the data in the initial post

MFelix's avatar
MFelix
Icon for Super User rankSuper User
10 months ago

Hi Jaggana ,

 

The sample data you provided is similar to the one I have created and based my measure on. Do you have any others aspects that can impact this? You refer that its more complex.

 

What is the final result you need.

 

You can upload a file using WeTransfer OneDrive or Google drive .