Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
108 | |
105 | |
77 | |
35 | |
35 |
User | Count |
---|---|
158 | |
103 | |
71 | |
65 | |
53 |