The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
hello everyone ,
i have a calculation
measure =
VAR value = sum([total])
RETURN
sumx(values(week nb),if ( [gross profit] > 0 , value , 0))
and i have a week slicer .
if i slect week 1, value was 10 but we were on a loss, so gross profit was negative so result of value gives 0
if i select week 2, value was 20 ,we were on profit, so gross profit was positive so result gives value 20
now if i select week 1 and week 2 together i am not getting getting 20 , iam getting 30. how can i solve this?
Solved! Go to Solution.
No error just didnt add up correct but i found a turn around and was able to fix my issue by adding the if to another measure formula that directly affect my formula similar to your suggestion,thank you for your time and help
what error do you get? And if would be good if you could also share the header of your data table, so to avoid spelling issues.
No error just didnt add up correct but i found a turn around and was able to fix my issue by adding the if to another measure formula that directly affect my formula similar to your suggestion,thank you for your time and help
User | Count |
---|---|
15 | |
12 | |
7 | |
6 | |
5 |
User | Count |
---|---|
24 | |
20 | |
12 | |
9 | |
7 |