Forum Discussion
Solution to COUNTA Function?
Hello all, I am very new to Power BI and I'm running into an issue I could use some help with. I assume I need to use CALCULATE / COUNTA for this? This is what I am trying to do: I have two table...
By your descrition it sounds like you could link these tables in the Table relationships section of Power BI.
Next you could create a matrix visual, which you can place the QA [ID] as the Row.
Lastly you could place BAT Testing[QA ID] into the values column and select "Count" as the metric.
Power BI will provide the results.
If you need this value as part of a larger measure, because you need the result. The measure mentioned by Mi2n will always be context sensitive, so if you are doing something on an ID basis, this should only count the related rows because of the table relationship.