English 中文(简体)
Why is my time intelligence measure not returning any results?
原标题:

Why is my time intelligence measure not returning any results?

This measure returns results:

Activity = 
COUNTROWS(FILTER( Inspection Data , [Inspection Type] = "Safety Activities"))

However, this one returns a blank:

Activity YTD = 
CALCULATE(
    COUNTROWS( Inspection Data ),
    DATESYTD( Inspection Data [End Date]),
     Inspection Data [Inspection Type] = "Safety Activities"
)

I am not getting error messages.

This is the relationship between the fact and date dimension table

Dimension table Date column format

Fact table date column

问题回答

暂无回答




相关问题
DAX expression for Power BI measure

I am trying to create a measure in POWER BI, its to calculate the total revenue for a time period but it has a lot of conditions to it. i.e. Total Revenue with following conditions Shipping type = &...

Android: Measure Size of View before rendering

I have a TextView that displays text that changes and run time. I want to use the View.getLineCount() method to see how many lines the TextView takes up and do different functions accordingly. The ...

Measure the run time in pascal program [closed]

Please, I need to measure the search time in my pascal program in order to measure the performance efficient.. if there is any function or code to measure the search time? thanks

Measuring online time on website

I would like to measure how much time a user spends on my website. It s needed for a community site where you can say: "User X has been spending 1397 minutes here." After reading some documents about ...

热门标签