How to implement var/return for dax calculation

Hi Team,

Can you please help how to implement or re-write below measure using var & return function?
Measure1=
IF(ISBLANK(CALCULATE(DISTINCTCOUNT(Query1[NxOpportunityIdentifier]), FILTER(Query1, Query1[actual_visibility_weeks]>=6))),0,
CALCULATE(DISTINCTCOUNT(Query1[NxOpportunityIdentifier]), FILTER(Query1, Query1[actual_visibility_weeks]>=6)))

Measure2=
IF(ISBLANK(CALCULATE(DISTINCTCOUNT(Query1[OpportunityId]),
FILTER(Query1, Query1[actual_visibility_Weeks]=0),
FILTER(Query1, Query1[0 visibility exclusions]="No"),
FILTER(ALL(Query1),Query1[1MUSD Flag]=1 && Query1[PipelineExclusionIndicator]="N")
)),0,
CALCULATE(DISTINCTCOUNT(Query1[OpportunityId]),
FILTER(Query1, Query1[actual_visibility_Weeks]=0),
FILTER(Query1, Query1[0 visibility exclusions]="No"),
FILTER(ALL(Query1),Query1[1MUSD Flag]=1 && Query1[PipelineExclusionIndicator]="N")
))

Thank you.

Regards,

Hari

Need Help

Hi harirao

smth like

Measure2=
var _tmp = CALCULATE(DISTINCTCOUNT(Query1[OpportunityId]),
FILTER(Query1, Query1[actual_visibility_Weeks]=0),
FILTER(Query1, Query1[0 visibility exclusions]="No"),
FILTER(ALL(Query1),Query1[1MUSD Flag]=1 && Query1[PipelineExclusionIndicator]="N")
)

RETURN

IF(ISBLANK(_tmp ),0, _tmp )

az38

6 years ago

harirao

there is no any magic

Measure1=
var _tmp = CALCULATE(DISTINCTCOUNT(Query1[NxOpportunityIdentifier]), FILTER(Query1, Query1[actual_visibility_weeks]>=6))

RETURN

IF(ISBLANK(_tmp), 0, _tmp)

3 Replies

az38
Community Champion
6 years ago
Hi harirao

smth like

Measure2= var _tmp = CALCULATE(DISTINCTCOUNT(Query1[OpportunityId]), FILTER(Query1, Query1[actual_visibility_Weeks]=0), FILTER(Query1, Query1[0 visibility exclusions]="No"), FILTER(ALL(Query1),Query1[1MUSD Flag]=1 && Query1[PipelineExclusionIndicator]="N") ) RETURN IF(ISBLANK(_tmp ),0, _tmp )
- harirao
  Post Prodigy
  6 years ago
  Hi az38
  
  Thanks for your reply, can you please provide a similar solution for Measure1?
  Measure1=
  IF(ISBLANK(CALCULATE(DISTINCTCOUNT(Query1[NxOpportunityIdentifier]), FILTER(Query1, Query1[actual_visibility_weeks]>=6))),0,
  CALCULATE(DISTINCTCOUNT(Query1[NxOpportunityIdentifier]), FILTER(Query1, Query1[actual_visibility_weeks]>=6)))
  
  Regards,
  Hari
  - az38
    Community Champion
    6 years ago
    harirao
    
    there is no any magic
    
    Measure1= var _tmp = CALCULATE(DISTINCTCOUNT(Query1[NxOpportunityIdentifier]), FILTER(Query1, Query1[actual_visibility_weeks]>=6)) RETURN IF(ISBLANK(_tmp), 0, _tmp)

Forum Discussion

How to implement var/return for dax calculation

3 Replies

Related content

VAR Table in RETURN statement

How DAX Execute VAR/ RETURN

return multiple Vars in Dax

var/return

MDM implementation