Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Hello, I have the follow dataset that has been denormalized (columns A-D). The result I'm looking for is in column G/H. I simply wanto a count of the Type field grouped by AnalyticID. As you can see in the data, a given AnalyticID will have multiple rows because of the Input column but for the most part AnalyticID and Type will be one-to-one, so if I could remove duplicates based on AnalyticID+Type, and then groupby it would work, but I can't quite figure out how to do that.
Any help would be appreciated.
Solved! Go to Solution.
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 )
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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 )
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
That seems to do the trick.. both responses worked but I accepted this as the solution as I was looking to do this in dax.
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.
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
106 | |
68 | |
48 | |
44 | |
42 |