Forum Discussion
Pass selected slicer value(Text) into a measure
Hi,
*I'm using Report Server Desktop "RS".
I have a slicer that shows text values instead of numbers. I would like to create a measure that takes the selected "text"value(Column A) in a slicer, filters Column B based on the selected value in Column A. Then returns a "count" or "distinct count" of the filtered rows.
I tried building a measure but I'm returned with a message "Cannot convert value XXXX of type Text to type Number".
This seems like a simple formula but I'm not using the right syntax for DAX.
Heres a table example:
Column A-Slicer filters on this column
| Dog |
| Cat |
Mouse |
| Horse |
Column B
| PitBull |
Corgi |
Tabby Cat |
| Jack Russell |
Thank you
2 Replies
Hi Anonymous ,
The error message "Cannot convert value XXXX of type Text to type Number" suggests that there might be a mismatch in data types being compared or operated on in your DAX formula. This is a common issue when dealing with text and numeric data types, as DAX expects explicit data type alignment for operations.
How would you like column A to be filtered and column B to be filtered? For example, if you select dog in slicer, will column B filter PitBull and Corgi? Is there another column that proves that PitBull and Corgi belong to dog?
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.