Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I’m stuck with this, the total is not showing the correct total. I am use the below measure and is working but for the total. Could anyone please help?
Total Bonus =
VAR AllBonus = SUM('table 1'[Sale Bonus Amount])
VAR ApprovedCust = SELECTEDVALUE('table 1' [ApprovedCustId])
VAR BonusEx = CALCULATE(SUM('table 1' [Sale Bonus Amount]) *2, 'table 1' [Sale Bonus Amount] = AllBonus, 'table 1' [ApprovedCustId] = ApprovedCust)
RETURN
IF(ISBLANK(ApprovedCust), AllBonus, BonusEx)
Solved! Go to Solution.
@Dtrain , You need to use group by of visual and create thsi formula assume, you are using ApprovedCustId in visual or use somthing else which is on row or non summarized
Total Bonus =
VAR AllBonus = SUM('table 1'[Sale Bonus Amount])
VAR ApprovedCust = SELECTEDVALUE('table 1' [ApprovedCustId])
VAR BonusEx = CALCULATE(SUM('table 1' [Sale Bonus Amount]) *2, 'table 1' [Sale Bonus Amount] = AllBonus, 'table 1' [ApprovedCustId] = ApprovedCust)
RETURN
sumx(values( Table[ApprovedCustId]), IF(ISBLANK(ApprovedCust), AllBonus, BonusEx))
for more than one column use summarize
Total Bonus =
VAR AllBonus = SUM('table 1'[Sale Bonus Amount])
VAR ApprovedCust = SELECTEDVALUE('table 1' [ApprovedCustId])
VAR BonusEx = CALCULATE(SUM('table 1' [Sale Bonus Amount]) *2, 'table 1' [Sale Bonus Amount] = AllBonus, 'table 1' [ApprovedCustId] = ApprovedCust)
RETURN
sumx(Summarize( Table[ApprovedCustId],"_1", IF(ISBLANK(ApprovedCust), AllBonus, BonusEx)),[_1])
@Dtrain , You need to use group by of visual and create thsi formula assume, you are using ApprovedCustId in visual or use somthing else which is on row or non summarized
Total Bonus =
VAR AllBonus = SUM('table 1'[Sale Bonus Amount])
VAR ApprovedCust = SELECTEDVALUE('table 1' [ApprovedCustId])
VAR BonusEx = CALCULATE(SUM('table 1' [Sale Bonus Amount]) *2, 'table 1' [Sale Bonus Amount] = AllBonus, 'table 1' [ApprovedCustId] = ApprovedCust)
RETURN
sumx(values( Table[ApprovedCustId]), IF(ISBLANK(ApprovedCust), AllBonus, BonusEx))
for more than one column use summarize
Total Bonus =
VAR AllBonus = SUM('table 1'[Sale Bonus Amount])
VAR ApprovedCust = SELECTEDVALUE('table 1' [ApprovedCustId])
VAR BonusEx = CALCULATE(SUM('table 1' [Sale Bonus Amount]) *2, 'table 1' [Sale Bonus Amount] = AllBonus, 'table 1' [ApprovedCustId] = ApprovedCust)
RETURN
sumx(Summarize( Table[ApprovedCustId],"_1", IF(ISBLANK(ApprovedCust), AllBonus, BonusEx)),[_1])
have a doubt related to this if we are crating a new measure to insure that total come correct should we use the correct total measure in bar and line chart visual also or we can use the same measure which is being used in table visual and giving the total value wrong but indivisual row value correct
Thank you for your support
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |