In PowerBI, I've created a couple tables (DateKey and Country-Area) that I use manage relationships to be able to filter on my reports. However when I use Anayze in Excel, those relationships se...
AndrewSEA
Advocate II
Advocate III'm mapping the main data to it. The table is called "Query1"
So the behavior I want is to filter on Area in the Analyze in Excel pivot, and the data with the Reseller_Country associated to the Area.