Forum Discussion

macintacos's avatar
macintacos
Regular Visitor
9 years ago
Solved

Measure Correct on Desktop, but Incorrect When Published

I have created a measure on Power BI Desktop to compute the number of late projects given a set of planned dates and actual dates in my dataset. The measure works correctly on Power BI Desktop and di...
  • macintacos's avatar
    macintacos
    9 years ago

    Hey thanks for responding.

     

    I deleted the measure and recreated it a few times, and suddenly the issue dissappeared...really unsure how it fixed itself, but I guess simplifying the formula (as mentioned above) and just clearing whatever cache it was working with (by deleting/recreating the measure) seems to have fixed it.

     

    I will come back to this thread if I run into this issue again.

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

macintacos

 

What's your data source?

 

I haven't reproduced your issue.

 

I created a sample table like yours, the measure shows same data in Power BI Desktop and Service.

 

Late Projects =
IF (
    ISBLANK (
        COUNTROWS (
            FILTER (
                DISTINCT ( SELECTCOLUMNS ( Table3, "Late", Table3[YESProjectLate] ) ),
                NOT ( ISBLANK ( [Late] ) )
            )
        )
    ),
    0,
    COUNTROWS (
        FILTER (
            DISTINCT ( SELECTCOLUMNS ( Table3, "Late", Table3[YESProjectLate] ) ),
            NOT ( ISBLANK ( [Late] ) )
        )
    )
)

 

 

 

 

 

Regards,

macintacos's avatar
macintacos
Regular Visitor
9 years ago

Hey thanks for responding.

 

I deleted the measure and recreated it a few times, and suddenly the issue dissappeared...really unsure how it fixed itself, but I guess simplifying the formula (as mentioned above) and just clearing whatever cache it was working with (by deleting/recreating the measure) seems to have fixed it.

 

I will come back to this thread if I run into this issue again.

  • lovedatsnow's avatar
    lovedatsnow
    New Member
    6 years ago

    I ran into this same issue. Was able to resolve by unpublishing the app, then republishing it. Looks like that may have reset from cache in the power bi service.