Forum Discussion

haiderAli's avatar
haiderAli
Frequent Visitor
4 years ago
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...
  • haiderAli's avatar
    haiderAli
    4 years ago

    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.
haiderAli's avatar
haiderAli
Frequent Visitor
4 years ago

Hi Valtterin,

 

Thank you soo much for your response. Unfortunately its not solving my problem. I have tried it but its showing me count of applications id even when I am applying filter for another user which has access to only one application. FYR I have attach SC : ( Its showing 19 applications which are total number of applications present in application table. 

 

v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi haiderAli ,

According to your description, I create a sample, the formula works when Application ID is filtered.

I attach my sample below, if you can't post your sample data, could you please modify my sample data to show your problem?

 

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

  • haiderAli's avatar
    haiderAli
    Frequent Visitor
    4 years ago

    Hi v-yanjiang-msft 

     

    Thanks for you response. 

     

    I have modified your sample data based on my problem. I hope you will understand my issue which I am currently facing. I haven't filled the security table but modified the data model and add all the columns that we have. Moreover, I want to display no of applications based on user account (SAM_ACCOUNT_ID) which I have applied filter on all the pages. 

     

    If a user has access to 16 applications, He should be able to see no of applications 16 not 19.

     

    Please send me your email address and I will share the update version of sample as I don't have option to attach the pbix file on this post as I am a new user.