Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have dataset simlar to open data
https://open.canada.ca/data/en/dataset/60459b47-af76-4b05-a0a5-38f706d5942a
where "Value" column could be number in thousands or percenrage (based on value in other column)
Question
To work with measure it easier to split table in 2 tables (percenatge and person) and define relationship or constantly filter out in measures percenatge or persons ?
Thank you
Solved! Go to Solution.
Hi @Alex_G7 ,
I think it is easier to implement it in Query Editor. You could duplicate the table and filter out "Person" and "Percentage " separately.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank a lot everyone . I used query editot to duplicate and filter table since values present Rate for each category (I had ucheck "sum values" when I created visualisation), final result belllow
Hi @Alex_G7 ,
I think it is easier to implement it in Query Editor. You could duplicate the table and filter out "Person" and "Percentage " separately.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You can write two measures for calculating the values for person and percentage separately. The measure will be:
1. calculate(sum('TableName'[VALUES]), 'TableName'[UOM] = "Persons")
2. calculate(sum('TableName'[VALUES]), 'TableName'[UOM] = "Percentage")
Regards,
Kamal
Addend Analytics
91.9920116645
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |