12-14-2020 05:13 AM
12-14-2020 05:46 AM
SolutionIn general yes, but that depends on how your data is structured. For such sample
creating PivotTable add data in data model. Create DAX measure like
VGT:=
VAR sumV=SUM(Table1[V])
RETURN IF( COUNTROWS(VALUES(Table1[A]))=1, sumV, sumV/2/8)
and use it instead of SUM aggregation. The logic of the measure - if you have only one A selected, you are on row and use SUM(), if more than one your are on Total and we use modified SUM().