No announcements
Found 2383394 threads
-
0 Votes
Date Slicer is Not Filtering Matrix Values Created by Measure
Hello - I have two visuals: a date slicer and a matrix. I need the values within the matrix to filter based on what is selected in theAnswered | 2 Replies | 676 Views | Created by CK127 - Tuesday, September 11, 2018 6:50 PM | Last reply by CK127 - Thursday, September 13, 2018 6:31 PM -
0 Votes
Slicer values got affected by calculated measure
specific metric that only affects say 'Toronto', and thus I created a measure for it. And once I put together a 'combined' calculation measure and put it ...Unanswered | 1 Replies | 875 Views | Created by dluhut - Monday, January 14, 2019 4:10 PM | Last reply by Ed Price - MSFT - Friday, April 5, 2019 6:33 AM -
0 Votes
Slicer on Measure?
We have 2 graphs, one that displays sales by month and another that shows fees by month. A user would like us to not show sales and fees on one chart, but to have a ...Answered | 3 Replies | 8859 Views | Created by KimberlyL - Thursday, September 1, 2011 3:06 PM | Last reply by Challen Fu - Tuesday, September 6, 2011 10:24 AM -
0 Votes
To Date Measure values
Thats a great starting point Javier. I worked on it some and here is what I came up with: with member [Measures].[Orders To Date] as ...Answered | 3 Replies | 3715 Views | Created by Reena BI - Thursday, July 14, 2011 7:01 PM | Last reply by Reena BI - Friday, July 15, 2011 3:21 PM -
0 Votes
Query: filtering date values
/2008" select e I also tried different date formatting like '1/1/2008', #1/1/2008#, "1-Jan-2008" etc....but none of them work. What ...Answered | 4 Replies | 7931 Views | Created by c.c.chai - Thursday, July 31, 2008 8:10 AM | Last reply by c.c.chai - Friday, August 1, 2008 3:20 AM -
0 Votes
Date Slicer not working
I have two tables and each table has two common columns (Date and Customer) that I want to slice and dice. The Date slicer does not filter TableB, how to ...Proposed | 2 Replies | 625 Views | Created by marc_hll - Wednesday, July 8, 2020 7:38 AM | Last reply by marc_hll - Thursday, July 16, 2020 8:21 PM -
0 Votes
Filtering Measure by Dimension members
ON ROWS FROM Cube Though MDX is defined by SELECT, FROM, and WHERE clauses, they do much different things than their SQL equivalents. I would recommend you take a ...Discussion | 1 Replies | 5806 Views | Created by ManikandanSubramani - Monday, July 6, 2009 3:01 PM | Last reply by Martin Mason - Monday, July 6, 2009 5:44 PM -
1 Votes
Calculated Measure result not affected by slicer or filters
Thanks Martin. How do we explain SSMS filter as well as Excel filter? They are not slicers and yet, filtering the months yield 365? Hope to hear from you ...Answered | 17 Replies | 1225 Views | Created by MichLing - Wednesday, March 1, 2017 7:45 PM | Last reply by MichLing - Tuesday, March 7, 2017 7:43 PM -
0 Votes
Filtering Measures by Measure Groups
I'm trying to create scripts to convert foreign currencies. I would like to create the script so that the measures are not hard coded but would be specified by MeasureGroup, ...Answered | 2 Replies | 7105 Views | Created by Martin Mason - Monday, August 28, 2006 1:22 PM | Last reply by Martin Mason - Monday, August 28, 2006 3:07 PM -
0 Votes
Filtering Measure by Dimension members
Thnx very much Gautham. I resolved it. You helped me in solving this urgent requirement in minutes by your quick reply. Keep going :) Cheers ...Answered | 4 Replies | 3582 Views | Created by ManikandanSubramani - Monday, July 6, 2009 3:04 PM | Last reply by ManikandanSubramani - Monday, July 6, 2009 9:40 PM -
0 Votes
Filtering Results By Date
If, by the execution time of the report, you mean the current date and time that the report is running; you could modify the query like ...Answered | 2 Replies | 3245 Views | Created by Mark Welford - Monday, September 21, 2009 4:30 AM | Last reply by Mark Welford - Monday, September 21, 2009 8:00 AM -
2 Votes
Filtering dimension by measure sum
Hi, I'm trying to filter dimension, by sum of measures. I want to filter members, that have atleast one measure greater than 0.Answered | 5 Replies | 4415 Views | Created by Milan Erić - Tuesday, November 2, 2010 1:54 PM | Last reply by Vinuthan - Wednesday, November 3, 2010 2:21 AM -
0 Votes
Filtering by date
I think Pure is looking for data comparison to current date by year and month like this:Answered | 4 Replies | 2543 Views | Created by Pure Deal - Thursday, December 8, 2011 11:01 AM | Last reply by Eric.Y.Zhou - Thursday, December 8, 2011 12:18 PM -
0 Votes
Filtering by Date (DateDiff)
Hi ChrisC2000, Based on my research, the issue is caused by IIF is not an expression, it is a function with three ...Answered | 2 Replies | 1445 Views | Created by ChrisC2000 - Monday, June 9, 2014 3:55 PM | Last reply by ChrisC2000 - Wednesday, June 11, 2014 8:42 AM -
4 Votes
Filtering Results by Date
display my results for these dates, for example From - To. My stored procedure is below, the column that I will need to use to filter by ...Answered | 6 Replies | 4040 Views | Created by NT86 - Monday, December 14, 2009 11:06 AM | Last reply by Alex Feng (SQL) - Tuesday, December 15, 2009 9:16 AM -
3 Votes
Dynamic Slicer Values
I know this question is old, but for others struggling with this, I have solved it by adding a new column with the dax ...Answered | 3 Replies | 11577 Views | Created by SERoof - Thursday, August 5, 2010 4:37 PM | Last reply by KatrineB - Friday, July 26, 2013 1:57 PM -
4 Votes
measure too complex for slicer?
Calendar Year in slicer will be greyed out. That is because the measure expects only one year: 2010, which is not available in ...Answered | 10 Replies | 5510 Views | Created by d_ddd - Monday, March 14, 2011 3:54 PM | Last reply by Ed Price - MSFT - Sunday, November 3, 2013 11:22 PM -
0 Votes
Filtering by Date in MDX
(Dimension : Resources , Measure: WorkingHours) Now I need to filter by a date range as well. The dates should be passed as parameter to the ...Unanswered | 5 Replies | 4013 Views | Created by Ramology - Tuesday, October 14, 2008 4:51 PM | Last reply by Nishant SQL BI - Wednesday, October 15, 2008 8:42 AM -
0 Votes
Filtering reports by date
.aspx Another method is to apply Top N filter over dataset in container and choose N value as 1Answered | 1 Replies | 416 Views | Created by MIDASuser - Wednesday, June 18, 2014 6:45 AM | Last reply by Visakh16 - Wednesday, June 18, 2014 7:00 AM -
0 Votes
A question about slicer & cumulative values
Since you're using a pivot table for the cumulitive sales all you need is a measure that looks like: Cumulative sales: =sum([salesamount]) -- ...Unanswered | 1 Replies | 13699 Views | Created by Bird007 - Thursday, February 16, 2012 8:59 AM | Last reply by Eric Hilton - Wednesday, February 22, 2012 3:14 AM - Items 1 to 20 of 2383394 Next ›
No announcements