Search

Power Pivot measure not showing in Power View report by ArtForum

Active

2
0
Sign in
to vote
Type: Bug
ID: 766244
Opened: 10/4/2012 11:50:20 PM
Access Restriction: Public
0
Workaround(s)
0
User(s) can reproduce this bug
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 (expand)

Product Language

English

Version

SQL Server 2012 - Developer Edition

Category

Reporting Services

Operating System

Windows 7 Professional

Operating System Language

Spanish

Steps to Reproduce

1. Create measure using formula provided.
2. Upload Power Pivot file into SharePoint.
3. Create Power View report using the uploaded Power Pivot File.

Actual Results

The created measure is not showing in the Power View report.

Expected Results

Measure created should appear in the Power View report, is visible and there's no reason why this measure should not be present.

Platform

 

Virtualization

 
File Attachments
0 attachments
Sign in to post a comment.
Posted by eric.rios on 3/20/2013 at 9:57 AM
same problem here
Sign in to post a workaround.