How to Create a Measure.

Anonymous — Wed, 30 Jun 2021 15:48:00 GMT

Hi All,

can any one please help me with the calculation for below condition.

Max of [TAT] at Opportunity ID
Sum of [TAT]
where Snap_Flag = Opportunity_Snap, [TAT] => 0
/
Unique count of Opportunity ID
where shot_Flag = Opportunity_Snap, [TAT] => 0

Thanks and Regards,

Harish

Re: How to Create a Measure.

V-lianl-msft — Fri, 02 Jul 2021 03:04:23 GMT

Please try:

Measure = VAR SUM_ = CALCULATE(SUM('Table'[TAT]),FILTER('Table','Table'[Snap_Flag]="Opportunity_Snap"&&'Table'[TAT]>=0)) VAR UNIQUE_ = CALCULATE(DISTINCTCOUNT('Table'[Opportunity ID]),FILTER('Table','Table'[Snap_Flag]="Opportunity_Snap"&&'Table'[TAT]>=0)) RETURN DIVIDE(SUM_,UNIQUE_)

If the problem persists, please provide your sample data and expected results.

https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

topic Re: How to Create a Measure. in Developer

How to Create a Measure.

Re: How to Create a Measure.