Forum Discussion

Wresen's avatar
Wresen
Post Patron
6 years ago
Solved

Change table values for slicer

Hi and thanks for reading this.   I have table with 3 columns, 2 of them have code in them but i would like to convert the code to measures since i have a few slicers that makes the condition to ch...
Need Help
  • JosefPrakljacic's avatar
    JosefPrakljacic
    6 years ago

    Hey Wresen ,

     

    now I understand you (atleast i hope 😛 )  - you want to have the slicer values to be calculated based on certain circumstances/slicings?

     

    Sry that won't be possible since you can't put measures in a slicer. By putting a calculated column in it this would also NOT be helpful since calculated columns and tables are preprocessed and later slicings wouldn't change the values in a slicer.

     

    BR,

    Josef

Ephsiba's avatar
Ephsiba
New Member
2 years ago
datescount =
CALCULATE(
    COUNTROWS(DimDate),
    FILTER(
        Facts,
        Facts[Months] =Facts[Months]="DEC-NOV"
    ),
    REMOVEFILTERS(dimemps[Employee Name])
)
 
works correctly and gives the correct result. But when i change the slicer of Facts[Months] from DEC-JAN to NOV-DEC it doesnt work. 

I changed the code as 
datescount =
CALCULATE(
    COUNTROWS(DimDate),
    FILTER(
        Facts,
        Facts[Months],Facts[Months]=Selectedvalue(facts[Months])
    ),
    REMOVEFILTERS(dimemps[Employee Name])
)
 
It doesnt work. gives only empty values