Forum Discussion

Lumegu's avatar
Lumegu
Frequent Visitor
4 years ago
Solved

Combining information without getting duplicate rows

Dear community,   I have a question and was wondering if this is even possible. I would like to combine the data from two queries (items_table and information_table) into one visual (desired output...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Lumegu ,

     

    Try to build your matrix by measure and transform it in Format. 

    I build a sample by your data. I turn off Stepped layout/ Word wrap function in Format and then reduce the width of columns which I don't need to 0.

    Then create measures as below.

    Amount of related information = 
IF(ISINSCOPE(information_table[Information number]),BLANK(),COUNT(information_table[Information])+0)
    Related information = 
IF(ISINSCOPE(information_table[Information number]), MAX(information_table[Information]),BLANK())
    Related Information Number = IF(ISINSCOPE(information_table[Information number]), SUM(information_table[Information number]),BLANK())

    Result is as below.

    Best Regards,
    Rico Zhou

     

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

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Lumegu ,

 

Try to build your matrix by measure and transform it in Format. 

I build a sample by your data. I turn off Stepped layout/ Word wrap function in Format and then reduce the width of columns which I don't need to 0.

Then create measures as below.

Amount of related information = 
IF(ISINSCOPE(information_table[Information number]),BLANK(),COUNT(information_table[Information])+0)
Related information = 
IF(ISINSCOPE(information_table[Information number]), MAX(information_table[Information]),BLANK())
Related Information Number = IF(ISINSCOPE(information_table[Information number]), SUM(information_table[Information number]),BLANK())

Result is as below.

Best Regards,
Rico Zhou

 

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