Forum Discussion
RuleName combination
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 🙂
thanks. let me try the solution
any suggestion as an SQL query
Hi Anonymous ,
For SQL Query, you can try to write it like this:
select case when RuleName in ('A','B') then 'AB' when RuleName in ('C','D','E') then 'CDE' when RuleName in ('F','G') then 'FG' end as RuleName, sum([Total Records])"Total Records", sum([Total Records Passed]) "Total Records Passed",sum([Total Records Failed]) "Total Records Failed", cast(cast(100 *(sum([Total Records Passed])/sum([Total Records]) )as decimal(18,1) ) as varchar(50))+'%' "Pass%", cast(cast(100 *(sum([Total Records Failed])/sum([Total Records]) )as decimal(18,1) ) as varchar(50))+'%' "Fail%" from Rules group by case when RuleName in ('A','B') then 'AB' when RuleName in ('C','D','E') then 'CDE' when RuleName in ('F','G') then 'FG' endBest Regards
Rena
Anonymous
If it is working, please mark it as a solution.