cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Measurement Calculation based on different Buy-Types

Hi Community

 

I would like to create an Pacing% Measurement which calculates based on the related revenue type. For example:

 

Pacing% = IF(LineData[Revenue-Type]="VCPM";
DIVIDE([Helper:Viewable-Imps];[Expected Budget]);
IF(LineData[Revenue-Type]="CPC";
DIVIDE([Helper:TotalRevenue];[Expected Budget]);
IF(LineData[Revenue-Type]="CPCV";
DIVIDE([Helper:TotalRevenue];[Expected Budget]);0)
))
 
But this if statements don't work on measurements just on custom columns. But the results in columns are static and wrong.
Does someone of you have an idear how to solve this smart?
 
THX,
Christian
2 REPLIES 2
Highlighted
Super User IV
Super User IV

Re: Measurement Calculation based on different Buy-Types

Hi @Anubis0815 

How about just use.

DIVIDE( [Helper:TotalRevenue]; [Expected Budget] )

Use LineData[Revenue-Type] as a table column or Slicer

Regards,
Mariusz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

Highlighted
Frequent Visitor

Re: Measurement Calculation based on different Buy-Types

Hi Marisz,

 

yes that works but just for one case. But In my data I have a lot of variations "Revenue Types" which needs different calculations. That is the reason why I would like to use if statements but this seems is not working with measurements.

 

Best,

Christian

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors