DAX remove duplicates or groupby

Hi sbuster 

Please try the following:

Data in Power BI (Table Name = SampleTable)

Measure 

DistinctCount Analytical ID = DISTINCTCOUNT(SampleTable[AnalyticID])

Result after putting int visual:

Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

It is for creating a new table.

New table =
GROUPBY (
    SUMMARIZE ( Data, Data[AnalyticID], Data[Type] ),
    Data[Type],
    "@Count", SUMX ( CURRENTGROUP (), 1 )
)