Forum Discussion

Caldowd98's avatar
Caldowd98
Helper I
4 years ago

Calculated measure IF statement in chart

Hi community

 

I have a calculated measure in my report that is an If statement, resulting in a 'yes' or 'no'.

 

I want to show in a pie chart, the number of records that it has calculated the 'yes' or 'no' for.

 

Whenever i drag the field into the visual, it automatically moves it to the tooltip and offers no option to sum or count.

 

Is there anyway around this ?

 

Thanks in advance !

Need Help

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    Please provide more details and maybe some sample data. This should be possible.

    • Caldowd98's avatar
      Caldowd98
      Helper I
      4 years ago

      Thanks for the response, ive created a small workbook sample but it wont let meattach this. Any ideas how i can share this ?

      Thanks,

      Cal

      • lbendlin's avatar
        lbendlin
        Super User
        4 years ago

        Can you use one of the file share services on the web?