Dynamic Visualization Filters
I have a forecast report and want to publish it in a BI system. But, I want the Year range to start 5 years before the year which has complete records. And I want to start the forecast line to ignore the last two years but in a filter. The reason why we wanted to use a dynamic filter instead of the usual common filters is that once the report is published, we aren't gonna have access to it. Can you give me ideas on how I can create a dynamic filter for my visualization?
Grouping in a measure
Hi, I have a measure called Measure 3 which is sum of Measure 1 and Measure 2. Where ever the Proportion class and Treatment Unit combo have Funding Type as both W and WMH, then the Measure 3 value should be calculated as Measure 1 (getting calculated only for FundingType = WMH, it will be blank for other Funding Types) + Measure 2 (getting calculated for Funding Type <> WMH, it will be blank for Funding Type = WMH) but its value needs to be displayed only at the first row of the Treatment Unit and remaining rows of cell Measure 3 should be blank in that Treatment unit. I am attaching the excel snapshot showing how it is getting calculated and displayed right now along with the desired result and format. How to achieve this ? Thanks
Comparision of Measures to evaluate a result
HI! I have a query with regard to comparing Measures to evaluate something and I am struggling with how this can be done..... An example of this is shown below. I have Employees in a Table that has multiple scores for on performance against a wide range of activities. However, I have created a Measure (Measure 1) that determines the score for the selected activity. I have another Measure (Measure 2) that is an expected score for the selected activity, so this is constant for a selected activity whereas individual scores will be different. What I am looking for is something that allows me to compare the result of Measure 1 against Measure 2 and then allow me to make an evaluation such as categorise the result in a range or percentage. I am sure this should be easy to achieve but I am not getting there......any suggestions would be great!!
