How to calculate a measure using a drillthrough filter

[till2718281828]

Hi everybody,

Pretty much often I need to calculate a measure presented below:

Drillthrough filters:

'Attribute 2' is "Xxxxx"

Attribute 1	Attribute 2	Value	Measure
Aaa	Z	100	100
Aaa	Xxxxx	10	10
Bbb	Z	100
Bbb	Y	20
Ccc	Z	100
Ccc	Y	10
Ddd	Z	100	100
Ddd	Xxxxx	20	20

So we need to:

1. find out the elements of 'Attribute 1' for which 'Attribute 2' is not NULL;
2. calculate the measure that sum 'Value' for such elements of 'Attribute 1'.

Can someone help with that

Thanks

[Eric_Zhang · Accepted solution]

---

@till2718281828 wrote:

Hi everybody,

Pretty much often I need to calculate a measure presented below:

Drillthrough filters:

'Attribute 2' is "Xxxxx"

Attribute 1	Attribute 2	Value	Measure
Aaa	Z	100	100
Aaa	Xxxxx	10	10
Bbb	Z	100
Bbb	Y	20
Ccc	Z	100
Ccc	Y	10
Ddd	Z	100	100
Ddd	Xxxxx	20	20

So we need to:

1. find out the elements of 'Attribute 1' for which 'Attribute 2' is not NULL;
2. calculate the measure that sum 'Value' for such elements of 'Attribute 1'.

Can someone help with that

Thanks

---

@till2718281828

As far as I know, the attributes 2 which is not in the drillthrough filter won't present the the drill through page. You can only get a total sum of the attribute 1 instead of individual sums.

Measure =
CALCULATE (
    SUM ( yourTable[Value] ),
    ALLEXCEPT ( yourTable, yourTable[Attribute 1] )
)