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.