Forum Discussion

Karthik12's avatar
Karthik12
Post Patron
3 years ago

Table Visualization from 2 different tables

Hello Folks, GM.  I am developing a production data display whereas data comes from 2 different tables. I would like consolidate in one matrix/table visualization as below   Expected format (Fil...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi  Karthik12 ,

 

Here are the steps you can follow：

1. Create calculated column.

Production Qty =
COUNTX(FILTER(
    ALL('Table1'),
    CONTAINSSTRING(
    CONCATENATEX(
    'Table1','Table1'[Type],","),'Table'[Type])=TRUE()
    &&
    'Table1'[Type]=EARLIER('Table'[Type])
    ),[Type])
Plan Qty =
COUNTX(FILTER(
    ALL('Table2'),
    CONTAINSSTRING(      
    CONCATENATEX(
    'Table2','Table2'[Type],","),
    'Table'[Type]  
    )=TRUE()
    &&
    'Table2'[Customer]=EARLIER('Table'[Type])
    ),'Table2'[Type])
Gap =
[Production Qty] - [Plan Qty]

2. Create measure.

Flag =
IF(
    MAX('Table'[Gap] ) <0,"red","green")

3. [Gap] – Conditional formatting – Background color.

4. Result:

When your entire Row is null, it will automatically default not to display.

If you want to display null values, you can click Show items with no data.

 

Best Regards,

Liu Yang

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

  • Karthik12's avatar
    Karthik12
    Post Patron
    3 years ago

    Anonymous Hi , Thanks for your time.

    It working fine but we have plan qty and prod qty is more than 1 (in table 1 and table 2) means this logic not working.

    Is there any solution for that?