Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello everyone!
Any help here is appreciated! Considering the following table example:
The current report is running the VALUE column with a standard SUM formula and is filtered by the COUNTRY column with a filter visualization.
I'd like to know if it's possible (and how to) to add on the formula the following context: if the filter equals "Brasil" then add 100.
Thx in advance,
Diego
Solved! Go to Solution.
Hi @Tulio_DL,
Please new a measure:
Total Value = IF ( CALCULATE ( ISFILTERED ( Table1[Country] ), ALLSELECTED ( Table1 ) ), IF ( SELECTEDVALUE ( Table1[Country] ) = "Brazil", SUM ( Table1[Value] ) + 100, SUM ( Table1[Value] ) ), SUM ( Table1[Value] ) )
Best regards,
Yuliana Gu
Hi @Tulio_DL,
Please new a measure:
Total Value = IF ( CALCULATE ( ISFILTERED ( Table1[Country] ), ALLSELECTED ( Table1 ) ), IF ( SELECTEDVALUE ( Table1[Country] ) = "Brazil", SUM ( Table1[Value] ) + 100, SUM ( Table1[Value] ) ), SUM ( Table1[Value] ) )
Best regards,
Yuliana Gu
Hello Shantanu!
Thank you for participating man, what you've said is a way to do the trick.... But I still need to know if there's a way to do what I've pointed out on the original post because my data table is a lot more complex than this example.
User | Count |
---|---|
121 | |
72 | |
71 | |
57 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
65 | |
55 |