Add context url to powerbi endpoint
Hello everyone, I asked a similar question a couple months ago but after testing out some options we are still on an empasse. Basically what we are trying to achieve is add a context url to each Report Server - Power BI virtual directory. Those are: /Reports /ReportServer /powerbi Through the use of an apache server, we managed to add the context we need in front of /Reports and /Reportserver, re-writing urls to /omr/Reports and /omr/ReportServer. We still have problems with the third virtual directory, which is /powerbi. What happens when you navigate to any dashboard inside a Report Server is that internally, the Web Page of the Report Server calls /powerbi endpoints to retrieve the corresponding data. The problem is that we need that endpoint to be rewritten to /omr/powerbi, but we cant do that server side. We need to have a way to change it in the fetch operation, when the request is sent. Is there any possibility to do this?
Is possible to ignore row filter context in a table ?
Hi! I have found various similar issues to this one in the forum but no one of solutions provided works for me 😞 I need for some calculations in a table, the value of the selected value in Group filter. It works OK in a card (as displayed in screenshot attached) , but, when I tried to use it in a table, it change between 2 and 3 (you can see in the table in the screenshot), I understand this is due to the row context filter is being applied to the measure. I need that the value "Selected Group" in my table remains being 3 (the one selected) not depending on row context filter, hoy can I reach that ? I tried with ALL, ALLSELECTED combinations with no success at all Currently my "Selected Group" Measure looks like: Selected Group = VAR currGroup = MAX('Table'[Group Code]) RETURN CALCULATE( MAX('Table'[Group Code]), FILTER ( ALLSELECTED('Table'), 'Table'[Group Code] = currGroup ) ) Thansk in advance!
Confusion with Filter / Context
Hi I am confused with some results using an explicit filter rather than an implicit filter. I have one fact table (ASB cases) and a Date table. The two tables have an active relationship between Calendar[Date] and ASB[Reported date]. I need a measure based on a Call Due date, where the call is made on time so am using USERELATIONSHIP. I have got the measure working based on the following. Initial Response on Time = CALCULATE(COUNTROWS('ASB Case'), USERELATIONSHIP('ASB Case'[Call Due to Reporting Party], 'Calendar'[Date]), 'ASB Case'[Contacted Reporting Party On Time?] = "On-Time" ) My initial Dax which returned incorrect results was Broken Initial Response on Time = CALCULATE(COUNTROWS('ASB Case'), USERELATIONSHIP('ASB Case'[Call Due to Reporting Party], 'Calendar'[Date]), FILTER('ASB Case','ASB Case'[Contacted Reporting Party On Time?] = "On-Time")) Clearly the way the filter is being used is wrong, but I can't really see the difference. I know Filter removes existing related filters first - so if anything was to happen I would have expected to see even more cases? If anyone can help I'd be really grateful. I'd also welcome any advice on steps I could take to debug the issue. Many thanks in advanveWrong Column Totals (Matrix)
I wrote a DAX measure that convert a YTD balance to a common currency (EUR). The measure works well when a single company is selected (1 currency) but generates a wrong Total column when I try to select 2 or more companies (currencies). Act_Eur_Ytd = VAR NUMERATOR = [Act_Lc_Ytd] VAR DENUMERATOR = CALCULATE(AVERAGE('Facts'[Avg_Ytd_Fx_Rate]), ENDOFMONTH('Calendar_Table'[Date].[Date])) RETURN ROUND(DIVIDE(NUMERATOR,DENUMERATOR),2) Example: The expected output of the matrix is: The current behavior of measure Act_Eur_Ytd is: When Company 1 alone is selected, Numerator properly sums EUR amounts and divides them by 1 When Company 2 alone is selected, Numerator properly sums CNY amounts and divides them by 0.1 When both companies are selected, Numerator sums EUR + CNY (wrong) and divides by an average (wrong). The exchange rate is linked to calendar, in order to convert at the latest average rate of the selected Month/Year. In order to give a better context, I attach the real life example, with source data. DOWNLOAD: Example (pbix) and Source Data (xlsx) I appreciate the help of the community to properly correct the syntax of my DAX measure. Thank you. Marco
Convert SAP BO measure with Foreach() operator to DAX formula
Hi I'm pretty new to SAP BO and I'm trying to convert a measure that I've found in a report to DAX language. The foruma uses the context operator FOREACH() on two columns ([Data].[KPI Group] and Data].[KPI Name] ) and I don't know how to write it in DAX. Could you please help me figuring out? Here's the code: SUM( IF( [Not Available] FOREACH( [Data].[KPI Group];[Data].[KPI Name] )="Y" ) THEN 1 ELSE 0 ) Thanks
