How to Create a Measure.

[Anonymous]

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

[V-lianl-msft · Accepted solution]

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