Thank You for posting your query onto the Forum.
So basically, you want to avoid writing the text manually which is mentioned under the quotes, is that it? If yes, in my file I’ve written the formula as follows to avoid writing the text manually. Below is the formula and screenshot provided for the reference -
Totals Sales Lookup =
VAR SelectedProducts = SELECTEDVALUE( Sales[Product Description Index] )
VAR Results =
CALCULATE( [Total Sales] ,
FILTER( Sales ,
Sales[Product Description Index] = SelectedProducts ) )
And then to have the “Grand Totals” at the bottom -
Total Sales Lookup (Totals) =
Products[Product Name] ,
[Total Sales Lookup] ) ,
In my file, the Sales (Fact Table) and the Products (Dimension Table) table is linked/related with the “Product Description Index” which is a common field. Similarly, in your file, you can follow the same pattern and get the results.
I’m also attaching the working of the PBIX file for the reference so that you can view how the formula is working.
Hoping you find this useful and meets your requirements that you’re looking for.
Thanks and Warm Regards,
Calculate Measure Filter From Different Table - Harsh.pbix (661.1 KB)