Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I'm currently trying to sum up the value of a column whenever my measure DisctinctCreativeCount returns a value more than 1. The data is all based on a single table. Since I can't simply create a visual with the number I need and apply a measure as a filter to it, I've created the below measures:
Measure that counts how many unique Creative IDs there are:
Measure that sums up the DBM Cost (Account Currency) whenever [DistinctTest] (which always returns 1) is less than the value my first measure returns. Had to create that column as I must have a column reference in the below for the "<" operator:
Solved! Go to Solution.
Hi @Anonymous ,
Sorry for the delay.
Please refer below measure to modify your measure and see if the result achieve your expectation.
CostOnOneCreative =
CALCULATE (
SUM ( 'BPR_DV360_Mapping'[DBM Cost (Account Currency)] ),
FILTER (
ALLSELECTED ( BPR_DV360_Mapping[DBM Line Item ID] ),
[DistinctCreativeCount] > 1
)
)
Result would be shown as below:
BTW, Pbix as attached, hopefully works for you.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Sorry for the delay.
Please refer below measure to modify your measure and see if the result achieve your expectation.
CostOnOneCreative =
CALCULATE (
SUM ( 'BPR_DV360_Mapping'[DBM Cost (Account Currency)] ),
FILTER (
ALLSELECTED ( BPR_DV360_Mapping[DBM Line Item ID] ),
[DistinctCreativeCount] > 1
)
)
Result would be shown as below:
BTW, Pbix as attached, hopefully works for you.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Worked like a charm Jay, appreciate the help!
Kind regards,
Ivan
Hi @Anonymous ,
Could you please share some sample data if you don't have any Confidential Information?
Just look at the measure doesn't seem to see any problem.
Best Regards,
Jay
Hi @v-jayw-msft ,
Thanks for looking into this! You can find sample data below:
https://docs.google.com/spreadsheets/d/1l0Le0-NHr23-3OGIZ6SaojLmMNh0nCSEqKKyd5BtsK0/edit?usp=sharing
It's a snippet of the main data.
Appreciate the help!
Kind regards,
Ivan
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
99 | |
97 | |
73 | |
72 |