Filter company aggregate measurement in Power BI

(0) Share

Report

Posted on by Community Member

Hello all,

I'm just learning using Aggregate Measurement of F&O in Power BI Desktop. Succeeded to use some of the Aggr.Measure, question is how to make it automatically filtered the company (dataareaid) of my F&O user id ?

Thanks,

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Jolanta Malkowska on at

Like (0)

Report

In some of the out-of-the-box Power BI reports, there is a Role implemented that filters data per company. The dataareaid is passed to the report when the report is called from the code.

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/secure-analytical-workspaces#help-secure-analytical-workspaces-and-reports-by-company

Example reports:

BankBalanceWorkspace.pbix
CFPBICashOverviewCompany.pbix
Credit and collections management V2.pbix
Purchase spend analysis.pbix
Sales and profitability performance.pbix
VendorPaymentAnalysisOverviewV2.pbix

Was this reply helpful? Yes No