Distinct Count of Object Per Type and Date

Hi,

You may download my PBI file from here.

Hope this helps.

Hi , Rabur116 

Try steps as below:

1.create a calculate table:

Table 2 = DISTINCT('Table'[Object Type])

2.create a mesure as below

value1 =
SUMX (
    GROUPBY (
        FILTER ( 'Table', 'Table'[Object Type] IN DISTINCT ( 'Table 2'[Object Type] ) ),
        'Table'[Date],
        'Table'[Object Type]
    ),
    IF (
        ISBLANK ( CALCULATE ( DISTINCTCOUNT ( 'Table'[Object Name] ) ) ),
        0,
        CALCULATE ( DISTINCTCOUNT ( 'Table'[Object Name] ) )
    )
) + 0

It will show as below:

Here is  a demo

pbix attached

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.