Is it possible to connect visuals without formulas?

[EdgarasR1]

Hi, community, 

Need some help and for you guys I think it's going to be an easy one:

So, I have two table visuals and I want them to merge into one. In the future it's going to more tables which the main criteria is "Employee" but others criterias are different because I'm using different filters for every column's values.

If its a easy formula then its very good too.

So, examples:

1st table's visual:

2nd table's visual:

The only diff between tables filters are that the first one has more selections from one selected column than the second.

The 1st table has selected debts stages: pre-trial, to law

The 2nd table has selected debts stages: recovery, pre-trial

Excel file --> Data 

And I need to have one table's visual instead of 2 but now I can't because filters are different and information doesnt match.

So, I need to create some seperate formula for new column or measure?

I'm using this filter module:

[v-angzheng-msft]

Hi, @EdgarasR1 

Not clear enough for me to understand what exactly you want to acheive.

Could you please consider sharing more details about it and posting expected result so it is clear on what needs to be implemented?  And It would be great if there is a sample file without any sesentive information here.

It makes it easier to give you a solution.

1. Sample (dummy dataset) data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
   

Best Regards,
Community Support Team _ Zeon Zheng

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

[amitchandak]

@EdgarasR1 , You should be able to put data together from common together. If employees and all these measures coming same data table, you can show them together. If they are from different tables, then you need need to create common dimension like employee two view things together

[EdgarasR1]

Okey, then the second question would be how to create 2 different measures by these criteria:

• Measure1DebtStagesActive = IF Debt stage = "Pre trial" or "To law" then SUM (Active debts amount)
• Measure2DebtStagesSelected = IF Debt stage = "Recovery" or "Pre-trial" or "To law" then SUM (Inflows)

Then I will put them in one table's visual and information will be correct?

Hope I have asked clearly.