Create column filled with measures

[Anonymous]

I want to create a bar chart wich gives the targeted value against the counted value of visit reports. 

The Bleu bars are the target. The others are all values from a created measure, which counts the number of visit reports from an other table filtered by acq/contr verl/klantonderh/ROS. 

Count acq bez = CALCULATE(COUNT('Bezoek rapport'[Outlet]);FILTER('Bezoek rapport';'Bezoek rapport'[Reason Visit]="Acq"))

Now I would like to have only the right measure compared to the right target. 

So "Doel bezoeken "acq"" against "count acq bezoeken"

I thought of an IF( formula that places the measer behind the column if the name is acq/contr verl/...

Can anyone tell me how to do this?

Or is there a better way to achive my wanted visual?

Thank you for your help!

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may drag [type] to Axis and take advantage of drill down.

[v-chuncz-msft]

@Anonymous,

Your requirement is not very clear. Show us a complete example, please.

[Anonymous]

Sorry, I will try to clarify

I have the following table:

Sales representative     |     Visited company      |     type     | 

Representative A                       Company A                  acq

Representative A                       Company B                  acq

Representative A                       Company C                  contr verl

Representative A                       Company A                  ROS

Representative B                       Company D                  Klant onderh

Representative B                       Company E                  ROS

Representative B                       Company F                  ROS

Representative B                       Company G                 acq

Representative C                       Company H                 Contr Verl

Representative C                       Company I                   ROS

etc

A second table:

Sales representative     |     type     |           Goal # visits     | 

Representative A                   acq                          150

Representative A                   ROS                         120

Representative A                   contr verl                   30

Representative A                   Klant onderh             80

Representative B                   acq                          200

Representative B                   ROS                         150

Representative B                   contr verl                   50

Representative B                   Klant onderh           100

Representative C                   acq                            80

Representative C                   ROS                         120

Representative C                   contr verl                 130

Representative C                   Klant onderh           180

The report pages are always shown with a filter on sales representative.

Right now I have created KPI visuals which count the number of visit companies with a filter on ""type".

And at target the "Goal # visits"

However, I still find this unclear because I get a lot of different visuals with number while it is not that important information on the report.

To make it more clear I would like to create a bar chart that shows The actual count of visits against the targeted. Seperated (legend) by type.

I hope this makes it more clear

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may drag [type] to Axis and take advantage of drill down.

[Anonymous · Accepted solution]

@v-chuncz-msft

It took me some time but I got it to work with the drill down.

But I had to create a seperate table in order to make a relationship between the 2 other tables.

Thank you very much for your help!

[v-chuncz-msft]

@Anonymous,

Glad to hear that. You may help accept solution. Your contribution is highly appreciated.

[Anonymous]

Thank you! I believe their is still a lot to learn for me.