Home Dashboard Directory Help
Search

Power Pivot measure not showing in Power View report by ArtForum


Status: 

Active


5
0
Sign in
to vote
Type: Bug
ID: 766244
Opened: 10/4/2012 11:50:20 PM
Access Restriction: Public
0
Workaround(s)
view
2
User(s) can reproduce this bug

Description

I created this measure in my Power Pivot,

:=IF(ISFILTERED(Geo[City]),VALUES(Product[Rank]),BLANK())

I created this measure because I want to display a value (Product[Rank]) only if City has been selected (dragged into a table). This works perfectly when I use it in a Excel (using a Pivot Table), but when I upload my file to SharePoint and try to use my measure, It's not showing, I have re uploaded the file several times and the measure is still missing!

When I upload the file I get no errors, everything works perfectly, is just this one measure that's giving me a headache.
Details
Sign in to post a comment.
Posted by Calvin Ferns on 6/19/2014 at 5:37 AM
Are we still awaiting a solution for this? there are alot of common DAX calcuations that need ISFILTERED such as Ratio to parent and http://www.daxpatterns.com/handling-different-granularities/ These are all spoiled for use in Powerview at the moment.
Posted by SLSData on 6/4/2014 at 3:37 PM
When do you anticipate a next major release? Do you not think this is a bug worthy of a fix? How can we use Power View if we can't see our measures?
Just curious.
Posted by Microsoft on 10/22/2013 at 11:03 AM
Thanks for finding this issue. We will consider a fix for this in the next major release.

Thanks,
Matt Jones
SSRS Tiger Dev
Posted by eric.rios on 3/20/2013 at 9:57 AM
same problem here
Sign in to post a workaround.