Forum Discussion

Stharwani's avatar
Stharwani
Advocate II
8 years ago

Values from measures not available in Excel

HI team,   I am connecting to Power BI dataset from Excel using the Excel Publisher. I am not not able to see values for some measures in the Pivot table in Excel, while those measures work absolu...
Need Help
Show and Tell
eborella's avatar
eborella
Regular Visitor
8 years ago

Hi

 

It seems there was no followup on this topic but I ran onto the exact same issue.

 

I'd like to display in an Excel pivot table those 2 measures values coming from the connected Power BI dataset:

 

1- SUM([timeoriginalestimate])/3600

2- CALCULATE(sum('jira_tempo_Worklog'[hours]),(1.0*(today()-'jira_tempo_Worklog'[workdate])<8),jira_tempo_Worklog[username] <> "admin")

 

Measure #1 does display values, but measure #2 does not.

 

Any ideay why?

 

Thanks

  • Stharwani's avatar
    Stharwani
    Advocate II
    8 years ago

    That could possibly be the issue with measure. Try breaking the measure down by individual Filter and see if that works. 

     

    My issue was different, the Excel connector wasnt stable, so I re-installed and older version and it worked. 

    • eborella's avatar
      eborella
      Regular Visitor
      8 years ago

      Indeed, the issue was in the measure itself. The data model was imported from Power Pivot and all the measures are working fine, but by looking into it I realised this calculate measure with multiple filters doesn't work. So the issue is not related the Excel connexion.

       

      Thanks