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.
sheap069
The best approach to get the desired results is to UnPivot the Attribute columns do the calculation using DAX.
Hi,
Could you provide an example please? How would I do the calculations? Do I do it in the Power Query Editor in the table?
Thank you
- Fowmy5 years agoSuper User
You can do the transformations in PQ and the calculations using DAX after loading the data from PQ.
To unpivot data, refer to this video: