Forum Discussion
Measure with specific filter ignored on interaction with table
Hi all,
i have a pivot table (matrix) and a slicer; the slicer interaction with the table is taken so that the table show all dimension values
and i want to create a measure which calculates count for selected value on slicer; ignoring the header dimension (A,B,C,D)
the figures need to be for A
matrix example
Brand A B C D
Sales1 10 10 10 10
Sales2 20 20 20 20
Sales3 25 25 25 25
where Sales1, Sales2 and Sales3 for A are 10, 20 & 25
the slicer selection is A
the measure is
measure =
VAR Brand_selected =
SELECTEDVALUE ( source[Brand] )
RETURN
CALCULATE(count(source[Value], FILTER(source,source[Value]<2 && source[Brand]=Brand_selected)))
can you help me with the correct syntax?
thanks,
Cosmin
3 Replies
- v-frfei-msftCommunity Support
Hi cosminc ,
Could you please share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
- cosmincPost Partisan
Hi
please find below a sample
the results which i need are already put on first post
Thanks,
Cosmin
Category Value Sales 1 1 Sales 2 0 Sales 3 1 Sales 1 0 Sales 2 1 Sales 3 0 Sales 1 1 Sales 2 1 Sales 3 1 Sales 1 1 Sales 2 1 Sales 3 1 Sales 1 1 Sales 2 1 Sales 3 1 Sales 1 1 Sales 2 1 Sales 3 0 - cosmincPost Partisan
keep in mind please that there are also other columns which i use as filters
so i can't use in measure All to ignore selections
thanks,
Cosmin