Forum Discussion
Counting items within group
Zoltan10 hard to say exactly the function because not sure how you consume your report but try this: (I assume in your table each row represent a manufacturer/model)
CALCULATE(COUNTROWS('Table'), REMOVEFILTERS('Table'), VALUES('Table'[Manufacturer]))
SpartaBI thank you very much. It works, but I realized, I asked the wrong question 😞
There are weights to the rows and I hoped the sum and count works the same.
Anyway I hope I can move forward with this logic.
Zoltan10 no worries, if you get stuck with replacing the COUNTROWS with the aggreagation logic you need just write back here and give me an example of few rows in the data you want to aggregate and how and I will reply with the edited measure.
P.S.
Check out my showcase report - got some high level stuff there
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Give it a thumbs up if you liked it 🙂