dzam
Reputation: 1
Power BI: Count the number of times a value appears in another table
I have 2 tables, one of which includes a column of id numbers. The other table has a column with multiple occurrences of each id-number. I would like to add a column to the first table telling me how many times each id appears in the second table.
Power Bi is new to me so I have gotten nowhere so far.
Upvotes: 0
Views: 5115
Answers (1)
msta42a
Reputation: 3741
If you have relationship between these two table on this ID then you can use simple measure:
CountOF = CALCULATE(countrows(detail))
Upvotes: 1
Related Questions
- Power BI - How do I count the number of times a value appears in relation to a separate column?
- Count Distinct Values in one column table related to another column table Power BI DAX
- How to count how many times a value appears in a list based on another column in Power BI?
- how can I summarize occurence from another table in a pbi table
- Count Multiple Rows from Multiple Table (Power BI)
- PowerBI : Count Distinct values in one column based on Distinct Values in another column
- Counting instances in a table in Power Bi
- Power BI : How to count occurrence of value from source table?
- Power BI, DAX--How do I count rows in one table based on values in another table?
- Power BI desktop count value occurance in some columns of one table