How can I display measure value as a top level in a drill down report

[Krunalbpatel]

I want to display total number of records on top level in a drop down chart. I want to show total number of records on X-Axis and when I drill down display category wise data. I have created calculated column to display total count but when apply filter using slicer the value doesn't change, it display the same count as before filter. I have created Mesure and count total number of records but I can not put measure on axis(Legend)

Please provide sollution for this. How can I achieve this?

[ankitpatira · Accepted solution]

@Krunalbpatel it is not possible the way you're trying. in axis field you can't drop aggregrate (ie calculated field). when you created calculated column and dropped it into axis field it wasn't number field and so using slicer you were not able to filter it since for calculated column each row has the same value.

what you can do is use category into axis field and again drop the same field into values section and select count which will give you count of category and you can then drop other fields onto axis to enable drill down.

[Krunalbpatel]

@ankitpatira Thanks for your reply 🙂