hi
i create a calculated measure with calculated query item in report studio (with Dimensional Functions)
tuple(parallelperiod(level(currentmember([CHQBOOKTYPE_Cube_H].[DimDate].[YearToMounth_Hierarachy])),1),[CHQCNT])
but
i define filter for calculated column , filter not give correct result
please help me
Hi,
Please provide more info, such as what the result is vs what the expected result. What are you trying to achieve with your filter?
if filter (measure value) set >=0 result is correct
but (measure value) set >0 result not view
Quote from: Behnamqmarsi on 10 Aug 2016 07:56:35 AM
if filter (measure value) set >=0 result is correct
but (measure value) set >0 result not view
Can you elaborate on what you mean by "filter"? Do you mean a slicer? Filter function in a query calculation? Detail filter?
MF.
Quote from: MFGF on 10 Aug 2016 08:54:31 AM
Can you elaborate on what you mean by "filter"? Do you mean a slicer? Filter function in a query calculation? Detail filter?
MF.
Hi
i explain for you my problem
i have a case study that contain of sales information in different month of years
i have one measure As "Sales Amount"
i need defined a same measure "sales amount" for 6 month period for current member: "6 period measure"
so i create that by calculated query with dimensional functions .
in this stage every things works right and Ok
I defined a filter .
when i used this filter "sales amount measure" i get correct result
my problem is :
filter dose not work for "6 period measure" and did not get any result.
now i want know how i can apply filter to "6 period measure"when run report
for example:
i want to filter sellers who have "6 period measure">100000000
unfortunately i do not understand hot to define appropriate expression for filter function
thank you for your help