Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Comparing different aggregations levels

So, this problem involves 3 tables. A master data table let's call it customer table. A category table, that related a customer number to a category. Finally i have a fact table holding transactions....
  • AilleryO's avatar
    AilleryO
    2 years ago

    Hi,

    If I get well your issue, you are looking for the ALL function.

    Using ALL( [CustomerKey] ) in your CALCULATE will remove the filter based on Customer key.

    Depending on your visual but according to your screenshot it might be :

    ALL( [CustomerKey], [CustomerName] )

    Hope it helps, let us know

AilleryO's avatar
AilleryO
Memorable Member
2 years ago

Hi,

If I get well your issue, you are looking for the ALL function.

Using ALL( [CustomerKey] ) in your CALCULATE will remove the filter based on Customer key.

Depending on your visual but according to your screenshot it might be :

ALL( [CustomerKey], [CustomerName] )

Hope it helps, let us know