New Table with calculated measures from other tables

[Anonymous]

Hi all, 

I have a number of tables (about 4) with different calculated measures in each one of them (All Clients, Engaged Clients, New Clients, Active Clients). Each measure is used in a number of multi-row cards (13 in total as they are grouped by region).

I would like to create one single table that has all these calculated measures by region. 

                  A Region     B Region     C Region

All Clients

New Clients

Active clients

Engaged Clients

or

Have a table for each region with these calculated measures.  

                A Region           

All Clients

New Clients

Active clients

Engaged Clients

What's the best way to go about it to get to the outcome?

[v-yingjl]

Hi @Anonymous ,

First, you should know that:

1. Calculation column/table not support dynamic changed based on filter or slicer.
2.  Measure can be affected by filter/slicer, so you can use it to get dynamic summary result.

https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

Then, sample data and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,

Yingjie Li

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

[JirkaZ]

You have to realize that measures don't belong to specific table but rather to the entire model. Using measures are all about the context. So if you have a measure calculating for example New Clients and you add some context to it (in this case region) the measures should re-calculate accordingly and show the correct values for each region.

[Anonymous]

I realise that now so I guess what I am after is the ability to have the same data that is shown in a multi row card, in a table (static or dinamic, I dk at this stage) that I can copy and easily paste in Excel/Word rather than entering data manually!