Forum Discussion
DAX Record Count - One to Many
Hi I am new to Power BI and DAX, I need help to write a query for my report. Can someone help me on this, please. In my data model I have one to many relationship between two tables, Reviews ...
mohsenvafa Create calculated column using below DAX,
CalculatedColumn =
IF( CALCULATE(COUNTROWS(ReviewResponses), FILTER( ReviewResponses, ReviewResponses[ReviewID] = EARLIER(Reviews[ID] ))) > 0, "True", "False")