Forum Discussion
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...
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
Hi Jaggana ,
If you don't provide a complete sample of your code it's difficult to pinpoint where you may need to change the formulas in order to get the correct value, depending on the context of the calculation a lot of changes may or not be needed.
Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.