ALL() and REMOVEFILTER() Don't Work Correctly on My Report
Hi, I have a problem that showing Lifetime amount by using ALL() or REMOVEFILTERS() functions on my report. I have created a new date table as slicer that implies Yesterday, Last 7 Days, Same Day Last Month, All, Custom etc., and it works perfect. But when I selected any slicer rather than "All", Lifetime Revenue does not show correct amount. Since the new slicer table consists duplicate dates, the cross-filter direction on relationship is not single as below. The dax query, I've used is to get Life Time Revenue: Revenue_Lifetime = CALCULATE( SUM(Revenue[Revenue]), ALL('Date Periods'[Date],'Date Periods'[Type]) ) Here is a sample report that shows the problem, https://we.tl/t-Q0SBtDHTFn Thank you, Kisa
Power BI Cross Filter Between Visuals Issue
Hi all - We have report created based on Direct Query using Azure Data Explorer as source. We have column called Duration which is computed in kusto i..e difference between StartTime - Finishtime ( Consider today's time in case of blank). I see the cross filter is not working once the minute passes ( Duration Column includes days hours minutes). Is there workaround to exclude the Duration Column in Cross Filtering. Also, When cross filteting happens, Is there way to force the filter to work on key column instead of all columns i..e Included in below pictue has all the columns. Cross Filter not works after minute passes: Note: DateDiff function is not supported in Direct Query mode for Azure Data Explorer. Data: Model: After Removing Duration Column , Cross Filter works fine Thanks, Abhriam
