Forum Discussion
Anonymous
6 years agoNot applicable
RuleName combination
nandukrishnavs
6 years agoCommunity Champion
Anonymous
You have to add a column "Group" to identify the group.
Refer the below example.
Sample Table.
| RuleName | Total Records | Total Record Passed | Group |
| A | 100 | 50 | 1 |
| B | 200 | 150 | 1 |
| C | 230 | 75 | 2 |
| D | 50 | 230 | 2 |
| E | 150 | 50 | 3 |
| F | 75 | 150 | 3 |
Calculated Table
Table 2 =
CALCULATETABLE (
SUMMARIZE (
'TestData',
TestData[Group],
"Rule Name", CONCATENATEX (
DISTINCT ( TestData[RuleName] ),
TestData[RuleName],
","
),
"Total Record", SUM ( TestData[Total Records] ),
"Total Record Passed", SUM ( TestData[Total Record Passed] )
)
)
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
Anonymous
6 years agoNot applicable
thanks. let me try the solution