Forum Discussion
Counting items within group
Hi All,
I stucked with a problem, so I need some help.
The situation is more complex, but I created some example for the situation.
Basically I would like to count the items within group like this:
In the real example the manufacturer is hidden, and the count must be calculated, because depends on the time dimension what I need to include.
How can I count the models for the rows?
Thank you for your help.
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]))
3 Replies
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]))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 🙂
