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. I am trying to sum values form a column but without specific records that are called "WAY TO FIRST CLIENT" and "WAY BACK HOME". The formula I am trying to use is below but it doesn't work. Could somebody please help me with that?
Solved! Go to Solution.
Hi @Anonymous
You can try something like below, but if you provide a data sample its always better.
Measure = CALCULATE( SUM( YourTable[ValueColumn] ), YourTable[FilterColumn] IN { "WAY TO FIRST CLIENT", "WAY BACK HOME" } )
Hi @Anonymous
You can try something like below, but if you provide a data sample its always better.
Measure = CALCULATE( SUM( YourTable[ValueColumn] ), YourTable[FilterColumn] IN { "WAY TO FIRST CLIENT", "WAY BACK HOME" } )
Mariusz I am sorry but the formula you've given me sums visits "WAT TO FIRST CLIENT" and "WAY BACK HOME" and I would like to sum everything WITHOUT these 2. What should I use instead "IN" in formula?
I worked it out I added "NOT" before Visits[VisitClientName]. You can see it below.
Hi @Anonymous
Happy you've sorted it!
Thanks
Mariusz
Thank you so much Mariusz it works!
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 |
---|---|
107 | |
94 | |
77 | |
63 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |