Forum Discussion
Countif for row based count (A:A=A2)
Super UserHi Raindeer,
Just to make this clear you just want to count how many times the A repeats in the full table right? You want this on a table visual.
Just add the ABC column on the table twice and change a summarization, if you need to have this calculated for using in a different way should use the measure.
Not really sure if this is what you want but this is a basic feature on PBI.
Or do you need to make any additional calculations or formulas.
Regards,
MFelix
Hi,
unfortunately my project is a little complex. The underlying goal is to weigh workload of individuals through counting the number of tasks they had at a given time. Each date and hour entry represent a task. I normally do this through countif in Excel.
In attached picture, lookup is just date and hour with hyphen in middle. Values in column "table 1" is count of occurance lookup values appear in table 1 [=countif(Table1!C:C=C2)]. Same logic is applied on table 2 and 3. Workload is sum of each row.
I need to do exactly this in Power BI for a KPI but it looks like an impossible task :(