Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have implemented drill-down to show the percentage of mobile voice users as the following:
Measure:
Count({$<[Use of Mobile Voice Service]={"Yes"}>} [Use of Mobile Voice Service])
/
Count([Use of Mobile Voice Service])
Dimension:
Level 1: Year
Level 2: Operator
The problem that the second level of drill-down is using only those "Yeses" which makes the above calculation is 100% for all operators.
Your expression work correctly in attached sample, may be your data is generating 100% results.
Can anyone provide a help in this regard ?
The results should be different and less than 100% for the operators in the second level.
Looks weird, I think the same measure should be execute for next level, is it possible for you to share sample app to look further on how did you define your drill down dimension.
Your expression work correctly in attached sample, may be your data is generating 100% results.