Absolutely. Just reference/duplicate your original query (called say “Data”), unpivot the new table and name it “Data Unpivoted”. Don’t link the latter into your data model with a physical relationship. If you need to incorporate it into your DAX calculations, do so using TREATAS. Here’s a similar solution I posted last night that uses this exact approach:
Thanks for posting your PBIX file. I’ll get back to you later tonight with a specific solution.
- Brian