Dynamic filter on measure based on prompt
I´m trying to filter a measure based on the prompt. The user is able to select an intervall for the time period (e.g. January 2015 - September 2015) in prompt. In the Report the user shall see the months 01-09 for one measure but also see the month 09 for the second measure.
But the user also should be able to select another Intervall of month (e.g. 01.2015-08.2015) then the second measure should be for 08.2015.
Is there a specific function which I can use?
Thanks and kind regards,
Mahboob Mohammed replied
Create the below 2 variables as measures.
- v_Max Month =If([Month]=Max([Month]) In Report) Then 1 Else 0
- v_Amt for Max Month =[Amount] Where (([v_Max Month]=1) In ([Month]))
You'll see that for all the Months & Distribution Channels, the measure v_Amt for Max Month shows the Amount from Max Month for that Distribution Channel.
Let me know if that helps.