First count the distinct id then find the row count of that count column

[gshaikh]

Hello 

Please see below We need 4 as an output as oracle output has 4 rows of output Request you to please find below dummy data

Thank you so much for help

Data

Orderno OrderLineNumber Shippeddate ScheduleDate
1232 4 14-11-2022 20211113
2323 6 16-11-2022 20221115
2323 5 16-11-2022 20221115
2323 7 16-11-2022 20221115
2323 8 16-11-2022 20221115
6556 6 24-11-2022 20211113
4543 7 23-11-2022 20221115
4543 8 23-11-2022 20221115

Query in oracle


SELECT COUNT(ORDERNO) CNT,
SCHEDULEDATE,
ShippedDate
FROM TABLE1
GROUP BY ORDERNO,
SCHEDULEDATE,
ShippedDate

Output In Oracle


Cnt ScheduleDate Shippeddate
1 14-11-2022 20211113
4 16-11-2022 20221115
1 24-11-2022 20211113
2 23-11-2022 20221115

Power Bi Output


4 4 Should be output as above Oracle output has 4 rows

[gshaikh]

Thank you so much for help its work for me Thanks again

[v-easonf-msft · Accepted solution]

Hi, @gshaikh 

You can new a summarized table and then count the rows of this summarized table:

Result2 = 
 var tab=SUMMARIZE (
    'Table',
    'Table'[Orderno],
    'Table'[ScheduleDate],
    'Table'[Shippeddate],
    "Cnt", COUNT ( 'Table'[Orderno] )
)
return COUNTROWS(tab)

Best Regards,
Community Support Team _ Eason