DAX Create Dynamic Virtual Table - Based on Slicer

[Lucky71]

Hi

I want to be able to create Virtual Table which is dependant on a slicer.
If Region slicer is...
being used:           Return the entire table
NOT being used:   Return a Summarized version of table (without the region field)

Entire table

CustAlias |Region    |Month          |Value

Cust 01	|Region1	| 30/06/2022	| 1350
Cust 01	|Region1	| 30/06/2023	| 1550
Cust 01	|Region2	| 30/06/2022	| 1350
Cust 01	|Region2	| 30/06/2023	| 1430
Cust 01	|Region3	| 30/06/2022	| 1650
Cust 01	|Region3	| 30/06/2023	| 1500

Summarized version of table (with region field removed)

Alias	Month	Value
Cust 01	| 30/06/2022	| 4350
Cust 01	| 30/06/2023	| 4480

I tried using....
IF  ISFILTERED(DateTable[Region])
Do this... <Return entire table>
Else...      <Return Summazied table> [Without the Region Field]

But IF will only return a Scaler value, and not a table.

Other posts have said you cannot return a table, but you can create a virtual table to then calc a measure value, but I 've not been able to make it work yet! 😫

Desired Output:

Where Region slicer is being used:          

			Measure1	Measure2
Region	|30/06/2022	|30/06/2023	|ARR Delta	|Analysis
Region1	|1350	|1550	|200	|Upsell
Region2	|1350	|1430	|80	|Upsell
Region3	|1650	|1500	|-150	|Downsell
Total	|4350	|4480	|130	|Upsell

Where Region slicer is NOT being used: 

			|Measure1	|Measure2
Alias	|30/06/2022	|30/06/2023	|ARR Delta	|Analysis
Cust 01	|4350	|4480	|130	|Upsell

Measure values will change dependant on if they are calculated on the entire table OR the summarized table.

Any help would really be appreciated. 
Thx 😁

[Lucky71]

Can anybody please help on this query?
Any help would be very much appreciated.

Thx 🙂

[foodd]

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

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

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

[Lucky71]

I've uploaded the PowerBI file here:

UploadFiles

Thank you