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) ...
Need Help
amitchandak's avatar
amitchandak
Super User
2 years ago

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
2 years ago

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
    2 years ago

    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...