Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello.
I have a list of plots, their area, and plant type, and their grower.
I want a column that will total the amount per grower and plant type (I've concatenated a column that gives me a text field of Grower+Planttype.)
Solved! Go to Solution.
not sure what's your data like, if you want to total the amount per grower and plant type, maybe you can try ALLEXCEPT() and FILTER() function,
e.g.
measure1 = calculate(sum(table[value]), allexcept(table,table[grower],table[plant type]))
measure2 = calculate(sum(table[value]), filter(table,table[grower]=min(table[grower]) && table[plant type] =min( table[plant type]) ))
If you need more help, please provide more details,
(1) a sample file, you can replace raw data with bogus data to protect your privacy.
or provide some sample data that fully covers your issue/question.
(2) give your expected result based on the sample you provide.
Kindly note: Please ensure the data in sample is concise and representative.
Thanks.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
not sure what's your data like, if you want to total the amount per grower and plant type, maybe you can try ALLEXCEPT() and FILTER() function,
e.g.
measure1 = calculate(sum(table[value]), allexcept(table,table[grower],table[plant type]))
measure2 = calculate(sum(table[value]), filter(table,table[grower]=min(table[grower]) && table[plant type] =min( table[plant type]) ))
If you need more help, please provide more details,
(1) a sample file, you can replace raw data with bogus data to protect your privacy.
or provide some sample data that fully covers your issue/question.
(2) give your expected result based on the sample you provide.
Kindly note: Please ensure the data in sample is concise and representative.
Thanks.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
I have also tried this:
Hey @Unicorn_Tech.
Try:
Total limit measure =
CALCULATE (
SUMX (
VALUES ( new_plotinformations[VarietyGrower Concat] ),
SUM ( 'Total per Grower'[Total Planted Ha Converted] )
)
)
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |