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 ) ThanksFilter on multiple measures for specific context
Greetings. I have a financial report that has an undeseriable output based on row context. For whatever reason accounting will post a expense transaction and then reverse so the total amount will be zero. It shows up in the report as shown below (Total Actual) since there are data values. I can't just filter out Total Actual <> 0 since there are times where there are budget transactions, but no expenses. I can't filter out Total Variance <> 0 since sometimes total budget magically equals total expenses. I need a measurement where it would filter out rows produced under a context where Total Budget = 0 and Total Actual = 0. I'm having issues producing a compund measurement that I could apply to the matrix visual to capture and filter out this scenario.
