Forum Discussion

Stharwani's avatar
Stharwani
Icon for Advocate II rankAdvocate 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