Forum Discussion

carlm1975's avatar
carlm1975
Frequent Visitor
8 years ago

Calculated Measure within a rotating tile

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 cou...
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi carlm1975,

 

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

 

Best Regards,

Dale

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi carlm1975,

     

    Try it in this file.

    The measure is:

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

    Calculated_Measure_within_a_rotating_tile

     

    Best Regards,

    Dale