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.
@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 🙂
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' end
Best Regards
Rena
thanks. let me try the solution
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 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |