Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Can someone help with that
Thanks
Solved! Go to 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:
- find out the elements of 'Attribute 1' for which 'Attribute 2' is not NULL;
- calculate the measure that sum 'Value' for such elements of 'Attribute 1'.
Can someone help with that
Thanks
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] ) )
@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:
- find out the elements of 'Attribute 1' for which 'Attribute 2' is not NULL;
- calculate the measure that sum 'Value' for such elements of 'Attribute 1'.
Can someone help with that
Thanks
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] ) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |