none
Display Measure value as a predefined level if no Dimension value is selected RRS feed

  • Question

  • Hi,

    Data: Table in PowerPivot as:

    

    Problem:

    I would like to show "UserCount" at Platform = "All" if Platform is not selected in Rows/Columns/Filter in pivot table after creating pivot table from PowerPivot

    Expected value should be

    Is it possible to create a measure which will check if any value from Platform dimension is selected or not and if not than display value at "All" level

    thanks in advance!!



    Rahul Kumar, MCTS, India, http://sqlserversolutions.blogspot.com/

    Tuesday, July 30, 2019 12:45 AM