Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello, I'm having trouble displaying a list of unique values for a second line of code that sum only the Lbs of values in that list, here is my code:
Total LT =
VAR list = CALCULATE(VALUES('DATA BASE'[OP]),'DATA BASE'[EE] = "LT")
RETURN
CALCULATE(SUM('DATA BASE'[Lbs]),'DATA BASE'[OP]=list)
here's a example of my data base (is a lot more bigger):
i want the list of the OP's that has some value in EE = LT, for later sum the total Lbs of that OP
Thanks
Solved! Go to Solution.
Hi @Anonymous ,
Try this measure:
If you consider it as a solution, please mark as a solution and kudos.
Ricardo
Hi @Anonymous ,
Please try the below measure:
CALCULATE ( [Total LBS], FILTER ( SUMMARIZE ( 'Data Base', 'Data Base'[OP], 'Data Base'[EE], "OP1", IF ( 'Data Base'[EE] = "LT", 1, 0 ) ), [OP1] = 1 ) )
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!
Hi @Anonymous ,
You can use the below measures.
Thank you @harshnathani , but this is not the result I'm expecting, the measure should sum all the values of the OP only if at least one are in LT, kind of first get rid of the list all the OP's that doesn't have at least one value with EE = LT, after that, sum all Lbs of each OP of this new list whatever the EE is. (i would like to graphic the EE values of every OP in a stacked column chart)
here i did a little example of the steps:
Thank you again for your help.
Hi @Anonymous ,
Please try the below measure:
CALCULATE ( [Total LBS], FILTER ( SUMMARIZE ( 'Data Base', 'Data Base'[OP], 'Data Base'[EE], "OP1", IF ( 'Data Base'[EE] = "LT", 1, 0 ) ), [OP1] = 1 ) )
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!
Hi @Anonymous ,
Try this measure:
If you consider it as a solution, please mark as a solution and kudos.
Ricardo
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |