Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Build Table from Calculated Measures

Hi,   I want to create a table from calculated measures that sit across multiple tables. Here's the result I'm trying to get to:     Here are some points to note:   All the information ...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi   Anonymous 

    If you hope to have the table interact with a slicer on the page, having everything including measures into a DAX table (calculated table) is not a good idea. This is because that calculated tables cannot be interact with slicers. To have interactive results, you need to create measures. So you need to have separate measures for Result and Icon. 

     

    Example:

    1. Create a measure for Result to pick the specific measure for each heading name:

    For the same Result measure, click Format dropdown box and select Dynamic. Then create dynamic format with a DAX formula like below.

     

    2. Create a measure for Icon. You can define different criteria for each measure to select URLs.

    Then you will have a table visual like below. Each measure may have different format. 

    For the Mesure heading table, you can use Enter data to create it easily. 

     

     

    Best Regards,
    Jing
    If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!