Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
eyoskan
Frequent Visitor

Analyze in Excel not showing values for some date filtered mesures

I have a number of mesures that try to calculate the YTD values. All those mesures are showing blank values when I try to use them in the Analize in Excel odc pivot as Values, although they have values in Power BI charts/tables. Below is an example of a mesure causing this issue.

 

Utilization = CALCULATE(
    [Chargeable hrs]/ [Available hours],
FILTER ( ALL ('Absorption total'[Date]),
            AND ( 'Absorption total'[Date] > date("2018","01","01"), 'Absorption total'[Date] <= [Selected Period End Date]
            )
       )
)

 

Any idea how this can be fixed?

1 ACCEPTED SOLUTION
eyoskan
Frequent Visitor

I just found the solution, I had to include the Period selecttion as a filter for it to show the data.

View solution in original post

1 REPLY 1
eyoskan
Frequent Visitor

I just found the solution, I had to include the Period selecttion as a filter for it to show the data.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.