Forum Discussion

acg's avatar
acg
Icon for Resolver I rankResolver I
4 years ago
Solved

Where Answer is 'Yes'

I want to calculate the number of Entities that had international Presence (= INT) in the last Year. International Presence is determined by answering to [Question Code] = "Q0035" with [Answer] = "Y...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi acg 
    can you please try 

     Number INT Presence YearMax =
VAR MAXSD = CALCULATE(MAX('Dim Submission Date'[date]),ALLSELECTED('Dim Submission Date'))
VAR MAXYSD = CALCULATE(MAX('Dim Submission Date'[year]),'Dim Submission Date'[date] = MAXSD)
RETURN
CALCULATE
(
COUNT('Fact QNA'[Companies]),
'Fact QNA'[Answer] = "Yes" && 'Dim Questions'[Question Code] = "Q0035",
'Dim Submission Date'[year] = MAXYSD
)
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi acg 
can you please try 

 Number INT Presence YearMax =
VAR MAXSD = CALCULATE(MAX('Dim Submission Date'[date]),ALLSELECTED('Dim Submission Date'))
VAR MAXYSD = CALCULATE(MAX('Dim Submission Date'[year]),'Dim Submission Date'[date] = MAXSD)
RETURN
CALCULATE
(
COUNT('Fact QNA'[Companies]),
'Fact QNA'[Answer] = "Yes" && 'Dim Questions'[Question Code] = "Q0035",
'Dim Submission Date'[year] = MAXYSD
)