Calculated Measure within a rotating tile

[carlm1975]

Hi, I have a custome tile on a report that rotates. I have 2 datasets that feed into the tile.

Dataset 1 is a complete list of "closures" all I do here is drag a field into the Measures and do a count of that field.

Dataset 2 is a table of targets by date. I have created a relationship betweeb the 2 datasets on date. The measure used from here is sumoftarget. This works perfectly, however I want to be able to calculate percentage of countoffield1/sumoftargets, any ideas how I go about this?

[v-jiascu-msft]

Hi @carlm1975,

Please share a sample and the expected result? How about function DIVIDE?

Best Regards,

Dale

[carlm1975]

@v-jiascu-msft

[v-jiascu-msft]

Hi @carlm1975,

Try it in this file.

The measure is:

Measure = DIVIDE(COUNT(Table1[Closed By]),sum(Table2[Target]))

Best Regards,

Dale

[carlm1975]

I have for example the following in dataset one

Date                    Closed By

01/01/18             Mr smith

01/01/18             Mr Jones

02/01/18             Miss Bunny

03/01/18             Mr Green

02/01/18             Mr Brown

In dataset 2 I have

Date             Target

01/01/18      4

02/01/18      4

03/01/18      1

In the measure section of my tile I would have

Count of ClosedBy = 5

Sum of Target = 9

I want to be able to create a third that gives me 5/9 as percentage

There is also a chart on the report that shows count of closed by as a bar and target as a line by day. Therefore when one of the bars is chosen the rotating tile auto changes to show figures just for that day.

Cheers

[carlm1975]

I dont know how to add countofclosedby / sumoftarget as a new measure