Expanded table

[Cyriackpazhe]

Here, if i write Values(Region Groups[Region Group]) won't i be able to restor the filter of Region group. Is it necessary that I write the entire table filter Region Groups as in the expression

[bhanu_gautam]

@Cyriackpazhe  

Yes, using VALUES(Region Groups[Region Group]) can restore the filter for the "Region Group" without needing to write the entire table filter. This approach is often more efficient and clearer. 

CALCULATE(
[Total Sales],
ALL(Customers),
VALUES(RegionGroups[Region Group])
)