locked
Basic Filter Query PowerPivot Excel 2013 RRS feed

Answers

  • Hello,

    For this you can use the following DAX formular:

    Closed Issues:=CALCULATE(DISTINCTCOUNT(SPDI[ID]), SPDI[IssueStatusValue]="Closed")

    The CALCULATE Function (DAX) offers 0-n optional filters, which is here used to filter on IssueStatusValue.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]


    Friday, September 30, 2016 4:17 PM

All replies

  • What is the other calculated field you tried to make?
    Friday, September 30, 2016 12:32 PM
    Answerer
  • =calculate DISTINCTCOUNT([Id]) filter IssueStatusValue = "Closed"

    i.e. how many id's do I have where the issue filter is not closed.

    Friday, September 30, 2016 1:23 PM
  • Hello,

    For this you can use the following DAX formular:

    Closed Issues:=CALCULATE(DISTINCTCOUNT(SPDI[ID]), SPDI[IssueStatusValue]="Closed")

    The CALCULATE Function (DAX) offers 0-n optional filters, which is here used to filter on IssueStatusValue.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]


    Friday, September 30, 2016 4:17 PM
  • Thanks, works a treat.

    Monday, October 3, 2016 8:10 AM