advice
4 TopicsIs this bad DAX, even though it works
I know that I always read about how tricky calculate can be and avoiding 'nested' calculates, so I'm looking for feedback. I have a measure that works, but there are nested Calculates, so I want to know if there is a better way. Model set-up table: Dates (well formed via Bravo) table: Projects Projects has a column 'Created Date' which is related to 'Date'[Date] via an inactive relationship. I'm returning the average number of projects created per month for the current year, so for 2025 that would be 'Count Projects' / 'Count Months' (2) (January & February). Here is the measure that works, but importantly you'll note that I'm nesting another measure [Projects Created] which itself is wrapped in a calculate. If I try to remove the calculate that wraps _result I get an OLE DB / ODBC error which cites [Projects Created] so I assume it has to do with the in-active relationship. If I try to direclty write the contents of the [Projects Created] measure into this measure it also fails. Main Measure: Avg. Proj Created by Mo current YR = VAR _currentYear = YEAR(TODAY()) VAR _Months = CALCULATETABLE( VALUES('Date'[Year Month]), FILTER('Date', YEAR('Date'[Date]) = _currentYear) ) VAR _result = CALCULATE( AVERAGEX( _Months, [Projects Created] ), USERELATIONSHIP('Date'[Date], 'Projects'[Created Date]) ) RETURN _result Nested Measure [Projects Created]: Projects Created = CALCULATE( COUNTROWS('Projects'), USERELATIONSHIP('Date'[Date], 'Projects'[Created Date]) )Solved624Views0likes3CommentsRestricting users to Export Data from Published report
Hi there Can someone please advise I have a report in a workspace with 20 people accessing. I now want to allow only 5 of those users to be able to export the data. If I do the following change the settings in the PBIX to allow export and republish to workspace In admin portal add the newly created security group with these 5 users to the export to excel and csv permissions what i'm finding is that everyone, not just the ones in the new security group, is able to export the data. Is there a way to ensure those not in the security are not able to export the data or do I have to create a copy and put that in a separate workspace Many thanks KarenSolved2.3KViews0likes7CommentsDAX Command Difference to Calculate Set of Data
Hello Power BI Expert, I am nearly completing my report in Power BI. However, it comes to my mind that I used two form of DAX when using "New Measure". Since I self-taught in Power BI, so here i am trying to understand what is the difference between these form of DAX writing (I use these two form the most): 1. Calculate(Countrows(table),Filter1,Filter2,Filter3)) 2. Countrows(Filter(table),Filter1&&Filter2&&Filter3) Both seem to provide same result in my data when calculating number of data in table. Another thing is, when i asked other people how to calculate data, they provide me with something like below. Looks like from SQL form of writing since I see that "window func SQL" (I might be wrong). the writing seems to be different than DAX. Is Power BI having more languange than DAX to be used in calculation? Thank you in advance.Solved1KViews0likes2CommentsView a Power BI report on Power BI Report Server from a different domain
We have Power BI Report Server installed on a server (Version1.14.8179.37378(May 2022)). A report has been uploaded to this instance which is viewed in an iFrame of another application. The instance of Power BI has been installed on the domain ABC. When users log on to the ABC domain they are able to view the report in the iFrame. There is a requirement that users in a different domain named DEF be able to log on to the application and view the report. However, when they tried it fails. We are able to successfuly add a user in the DEF domain to the browser role in the instance of Power BI Report Server. However, when that person goes to the URL of the report, she is unable to view the report. So, Power BI Report Server is installed on the ABC domain. It is able to authenticate users on the DEF domain. What would we have to do so that users on the DEF domain can view the report?715Views0likes2Comments