Filtering and measures are wrong to filter dynamically

[chaitanya1]

Here’s a summary of the tables in your Power BI project along with their columns:

Users Table:

Family Name
Given Name
OwnerTenantGUID
UserGUID
UserPrincipalName
EmailID

Views Table:

Date
Platform
ReportGUID
ReportPage
ViewersCount
ViewsCount
UserGUID

Reports Table:

Display Name
ReportGUID
SalesKpiColumn
Dates Table:

Date
Day
Month

Role Based Access Sheet:

KPIs/Reports 
Organisation
*Role based access sheet is template source data and remaining all are direct query data, so role is connected to reports it is filtering other tables virtually but not directly. ViewsCount and ViewersCount already a measures in project. I have used each in two visuals in one page. i have a filter organisation(companies list), when i change that company name four visuals should change accordingly dynamically  i tell what is those visuals please help me 1.  clustered bar chart- viewscount from Views and saleskpicolumn from reports, 2. Clustered barchart-viewerscount from views and saleskpicolumn from reports, 3. linestackedcolumn chart- x-axis:date column from dates, column y-axis: viewscount so this is coming dailyviews day by day, 4. linestackedcolumn chart -x-axis:date column from dates, column y-axis :viewerscount daily viewers for each day it will show. 
* I need to filter dynamically since it is direct query i can;t connect role to all tables i connected to reports only, so whenever i change organisation filter those 4 visuals not filtering correctly according to each company in dropdownlist i am trying from weeks own measures i am unable to finish it please help me. how to filter those visuals. Viewscount and Viewerscount already measures this data came from microsoft fabric. how to filter dynamically.
* I hope all info i kept in this please help me. FOR views table reports, users, dates connected, for reports table role based access sheet connected. Role is template source data so filtering issues. Role is connected to saleskpicolumn in reports via kpis/reports column in role.

[Anonymous]

Hi, @chaitanya1 

Could you please help me check whether my data structure and content align with your original data, particularly regarding the table relationships? Based on your description, I’m uncertain how the Organisation field in the RoleBasedAccess table relates to the overall data, especially the view table.

However, based on my experience, if you have a field that can be associated with the Organisation field in the RoleBasedAccess table, you might consider trying the following measure:

FilteredViewsCount = 
CALCULATE(
    SUM('Views Table'[ViewsCount]),
    FILTER('Views Table','Views Table'[ReportGUID] IN VALUES('Reports Table'[ReportGUID])
))

That said, due to the ambiguity in the table relationships and fields, I cannot guarantee that it will be effective.

Can you share sample data and sample output in tabular format if I am misunderstanding? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

When uploading a file, please be careful to delete sensitive information.

For questions about uploading data, you can try the following links:

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Solved: How to upload PBI in Community - Microsoft Fabric Community

Here are similar posts that I hope will help you:

Solved: Re: Calculate percent columns by several tables - Microsoft Fabric Community

Solved: How to setup a visual for a table with only a sele... - Microsoft Fabric Community
 

Please find the attached pbix relevant to the case.You can also modify it according to the pbix file I provided, so that I can better understand your problem environment

Best Regards,

Leroy Lu

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

[chaitanya1]

HI, Thanks helping me.That filtered views measure should filter by organisation column in role based access sheet table that is template source data remaining all are direct query so role table i cannot to all tables so it is connected to reports remaining tables are filtering virtually not directly that's my issue those 4 visuals filteredviews count and filtered viewers count with reports[saleskpicolumn] and dates[date] should filter by dates[date] and role based access sheet[organisation] filters in single page.