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.
Dear All,
i want my "what if parameter" to affect only certain row in table - if the condidion is met (screen below), for example:
when i will hard code value of 20 inside DAX calculation it's working fine - there is 50 bikes in last column, but when im changing it to Extra bikes parameter value - nothing is happening, it doesn't see param value ....what am i doing wrong here ?
Solved! Go to Solution.
ok, i think i got this one ! switch statement with default parameter solved the problem of wrong totals
ok, i think i got this one ! switch statement with default parameter solved the problem of wrong totals
HI @BarSi1986
Try this measure:
Measure =
Var _A =[Extra bikes Value]
return
if(max(Items[Item])="bikes",sum(Items[Quantity])-'Extra bikes'[Extra bikes Value],sum(Items[Quantity]))
Output:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
Well, it fixed problem on row level here, but still doesn't affect TOTAL - we have 10+20 items, and the total of column is still 50, any ideas ? cause im still new in DAX 😞
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |