Forum Discussion

ivicaSD's avatar
ivicaSD
Frequent Visitor
9 years ago
Solved

Choosing a column from a table using slicer

Hi, experts! I am making a Salary Analysis report (matrix), which shows number of employees in certain categories (work experience by qualification). This is the example:             ...
Need Help
  • ivicaSD's avatar
    ivicaSD
    9 years ago

    I think I know what the problem is!

     

    The matrix (and also stacked bar chart or stacked column chart) persistantly shows me the values for TODAY, no matter which combination of slicers I make. This indicates that slicers have no effect on my measure...

     

    The conditions (IFs) work fine, I have tested them... they react to slicer choices. Something is wrong with the functions I use (COUNTX, and I even tried with SUMX and then making a new measure as COUNTX('Calculated Experience'; [SelectedCalculation]) )

     

    Any ideas?

ivicaSD's avatar
ivicaSD
Frequent Visitor
9 years ago

 

There is one good advice, found on site http://www.daxformatter.com/ in comments:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

I will refactor my code now and see if it helps! :)

ivicaSD's avatar
ivicaSD
Frequent Visitor
9 years ago

 

Unfortunately, refactoring the code didn't solve the issue. I still get the results for "Today" and they don't change when I change various slicers... At least, I know that my code is more efficient now... ;)