Forum Discussion
Solved
Create a count measure which count rows from multiple tables in my organization data model
Hi, Can any body please help me with that? Query: I want to create a measure to show me count of applications id which I will display on card. Applications id are column in dim application tabl...
Hi all, thanks for your responses. I have find a way for solving this problem by creating measure.
Count_Application = "Total number of Applications: " & CALCULATE(distinctcount('Dim Application'[Application_ID]),FILTER(Security,Security[IsSummaryAllowed]=1))Thanks everyone for posting answers on my query.
Hi all, thanks for your responses. I have find a way for solving this problem by creating measure.
Count_Application = "Total number of Applications: " & CALCULATE(distinctcount('Dim Application'[Application_ID]),FILTER(Security,Security[IsSummaryAllowed]=1))
Thanks everyone for posting answers on my query.