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.
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.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |