Forum Discussion
Measures in Table Visual
- 5 years ago
Hi, sheap069
Try follow steps :
1.Add a custom column to mark table name in each table2. 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 () ) ) + 0Count_value_true = CALCULATE ( COUNT( Append1[Value] ), FILTER ( ALLEXCEPT ( Append1, Append1[Table Name], Append1[Attribute] ), Append1[Value] = "True" ) ) + 0Rate = [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.
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 ()
)
) + 0Count_value_true =
CALCULATE (
COUNT( Append1[Value] ),
FILTER (
ALLEXCEPT ( Append1, Append1[Table Name], Append1[Attribute] ),
Append1[Value] = "True"
)
) + 0Rate = [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.
Thank you very much, this has the desired result!