Forum Discussion

sheap069's avatar
sheap069
Helper III
5 years ago
Solved

Measures in Table Visual

Hi, I have two data sets as shown here (sample data and expected result)   data 1 Application ID Attribute 1 Attribute 2 Attribute 3 Attribute 4 1 TRUE FALSE FALSE TRUE 2 FALSE ...
  • v-easonf-msft's avatar
    5 years ago

    Hi,  sheap069 

    Try follow steps :
    1.Add a custom column to mark table name in each table

     

    2. Upivote attribute columns  as below:

    3.Append queries as new query and then close & Apply

    You will get a new table as below:
    (make sure the field "Value" is text type)



     

    4.Create measure as below:

    Count_value = 
    CALCULATE (
        COUNT  ( Append1[Value] ),
        FILTER (
            ALLEXCEPT ( Append1, Append1[Table Name], Append1[Attribute] ),
            Append1[Value] <> BLANK ()
        )
    ) + 0
    Count_value_true = 
    CALCULATE (
        COUNT( Append1[Value] ),
        FILTER (
            ALLEXCEPT ( Append1, Append1[Table Name], Append1[Attribute] ),
            Append1[Value] = "True"
        )
    ) + 0
    Rate = [Count_value_true]/[Count_value]

     

    The  result will show as below:

    Please check my sample file for more details.

     

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.