mrchonginhk
Well-known Member
- Joined
- Dec 3, 2004
- Messages
- 679
I have this DAX and is getting what I want which is to
DAX1= Calculate( SUMX( Data,Sum(Data[Pct]) ), filter( Data, Data[Attribute] in ALLSELECTED(Selector1[Choices]) ) )
However, each cell is still respective filtered value based on Choice.
Suppose there are 10 choices and if only 2 are selected, I want each cell to show the same 2 choice values added up instead of showing respective choice's value.
For example, The choices are A, B, C.... etc and the respective values after their are:
A=1, B=2,.... J=10
If the selected choices are B and C, then I want all cells are returning
2+3 = 5, ie all cells to return same 5
How to modify ?
Thanks
DAX1= Calculate( SUMX( Data,Sum(Data[Pct]) ), filter( Data, Data[Attribute] in ALLSELECTED(Selector1[Choices]) ) )
However, each cell is still respective filtered value based on Choice.
Suppose there are 10 choices and if only 2 are selected, I want each cell to show the same 2 choice values added up instead of showing respective choice's value.
For example, The choices are A, B, C.... etc and the respective values after their are:
A=1, B=2,.... J=10
If the selected choices are B and C, then I want all cells are returning
2+3 = 5, ie all cells to return same 5
How to modify ?
Thanks