Forum Discussion

Jaggana's avatar
Jaggana
Advocate I
9 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
Advocate I
9 months ago

Thank your for your time, but as I wrote I drastically simplified the code, what I really need is to condition the value of the variable between 2 variable tables

v-nmadadi-msft's avatar
v-nmadadi-msft
Community Support
9 months ago

Hi Jaggana ,

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

Please show the expected outcome based on the sample data you provided.
Thank you

  • Jaggana's avatar
    Jaggana
    Advocate I
    9 months ago

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

    • MFelix's avatar
      MFelix
      Super User
      9 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 .