Forum Discussion

robertnoble's avatar
robertnoble
Regular Visitor
2 years ago

Measure Showing Blank Value When Using Slicer

Hi All,

 

Very new to this and running into trouble. I have the following measure created in the Chang Log fact table to calculate the date difference between two statuses.

 

 

Time in Dev (s) = 

var DevStart = CALCULATE(min('Change Log (Status)'[Change Time]), filter('Change Log (Status)', [items.to] = "3"))
var DevEnd = CALCULATE(min('Change Log (Status)'[Change Time]), filter('Change Log (Status)', [items.to] = "11046"))
var DevTime = DATEDIFF(DevStart, DevEnd, SECOND)

return DevTime

 

 

 

This is my data tables:

The issue arises when I try to use a Sprint slicer (from the dimSprint) to filter to my measure in the Change Log table. I end up with something like this:

You can see that the Sprint filter works (right table), I get Issue Keys (from Issue Data), but in the left table when I add the measure, it returns no results (I double checked the data and there should be results there).

I am not sure if it is the relationships between the tables or the measure itself. I have tried a few things and still no result. I tried creating the measure in the Issue Data table and it still does not work.

 

My goal would be to able to filter on dimSprint and show combined data from Issue Data (issue key) and Change Log (my measure)

 

Any advice/suggestion would be appreciated.

3 Replies

  • robertnoble , If you select one status, then for other status you need to ignore the filter

    var DevEnd = CALCULATE(min('Change Log (Status)'[Change Time]), filter(all('Change Log (Status))', [items.to] = "11046"))
    
    or
    
    var DevEnd = CALCULATE(min('Change Log (Status)'[Change Time]), filter(all('Change Log (Status)[items.to])', [items.to] = "11046"))

     

    Compare Categorical Data Using Slicers, Compare Two Brands/Categories/Cities: https://youtu.be/exN4nTewgbc

     

    • robertnoble's avatar
      robertnoble
      Regular Visitor

      That did not work. I tried both variations on the measure.

      When I switch the return to DevStart I will works but it shows just one result instead of the result for each issue. My guess is that min is returning the min among those issues not the min for each issue as I wanted.

      • robertnoble's avatar
        robertnoble
        Regular Visitor

        Apparently some of the changelog data wasn't loading. I had filtered in PowerQuery to just status. I unfiltered it. Got my data, then reapplied the filter and now it works...