DAX Query Support - Expert Cube Development with SSAS Multidimensional Models - page 357

• Some measure format strings, including some of those that return string,
date, or Boolean values such as True , False , On , or Off , will not work.
Format strings applied to null values are likewise ignored.
• Calculated measures are fully supported, but calculated members on
dimensions other than the measures dimension are only partially supported.
Calculated members on attribute hierarchies of non-measures dimensions
will only appear if they are a child of the All Member and there is at least
one other real member, or if there is no All Member and there is at least
one other real member. Furthermore, the attribute hierarchy with the
calculated member cannot be the key attribute of the dimension unless the
key attribute is the only hierarchy on the dimension. Calculated members on
user hierarchies and parent/child hierarchies are not supported. This means
that most of the Calculation dimension techniques described in Chapter 6 ,
Adding Calculations to the Cube will work with Power View.
• Parent/child hierarchies are supported, but they appear as flattened
structures with repeating values. This is not very user-friendly.

• Certain DAX functions such as Path() are not supported.

• There is no way to use Actions in Power View.

New functionality in Analysis Services
There are two small new pieces of functionality in Analysis Services that support
specific Power View features:

• To enable Power View to use an attribute in a map, you have to set

the following:
° The dimension's Type property to Geography
° The attribute's Type property to something in the Geography
category, such as Country

• To enable Power View to treat the name of a member on an attribute

hierarchy as a URL pointing to an image so that the image can be displayed
in a dashboard, set the attribute's Type property to Image\ImageURL