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.
- sheap0695 years agoHelper III
Thank you very much, this has the desired result!