Questions related with context

Hi, I'm new to Power BI.

I have dimCust table as follow:

| CustID | CustName | CustAge | CustLoc |

And Sales table as follow:

| SalesID | CustID | Date | ProductID | Qty |

The relationship is as follow:

I then created a measure table consists of several measures as follow:

1. VisitQty = COUNT('Sales'[SalesID])
2. EarliestVisit = MINX(Sales, [Date])
3. LatestVisit = MAXX(Sales, [Date])
4. PeriodDay = DATEDIFF([EarliestVisit], [LatestVisit], DAY)
5. TotalPeriod = CALCULATE([PeriodDay], ALLSELECTED('dimCust'[CustID]))
6. TotalVisit = CALCULATE(COUNT('Sales'[SalesID]), ALLSELECTED('dimCust'[CustID]))
7. Visit/Period = DIVIDE([TotalVisit], [TotalPeriod])

Then in the report view, I chose Table Visualization and filled it with columns and measures:

• CustID taken from dimCust table
• Other columns are from the above measures

When I excluded CustName column as the above, the last 3 columns consist of fix total value for each column in all rows (red box), as I wanted it.

And as I filtered the CustLoc using slicer, the total values will also be adjusted and each row will still be filled with the fix total value as follows:

But when I included the CustName column, it filters the CustID column and the values in last 3 columns become only for the particular rows, as follows:

One more thing, I added other measure and included it in the table:

1. VV = DIVIDE(([VisitQty] - [Visit/Period]*[PeriodDay])^2, [PeriodDay])

The result for each row is correct, but the total value become zero, as follows:

I have 3 questions:

1. How to show all CustID after add CustName column?

2. How to keep fix total value in each row based on slicer filter after add CustName column?

3. How to show correct total value for VV column?