Forum Discussion
Calculate Filter Ignoring in Table visual
Something strange is happening with my measure and I can't figure out why / what I need to do to make it work properly. Any advice would be great. I have a table, simplified below, and on the page there is a slicer for country. I am using a table visual to display the items for the selected country and also price, with the correct currency.
| Country | Item | Price | Currency |
| 1 | AAA | 100 | GBP |
| 1 | BBB | 200 | GBP |
| 2 | CCC | 300 | USD |
| 2 | DDD | 200 | USD |
| 2 | EEE | 100 | USD |
My measure currently looks like this, where Measure1 is a simple average(price) measure. When I add this measure as a field to the table visual it displays the items from all countries, just with blanks in this column.
Measure2=
VAR SelectedCountry =
SELECTEDVALUE(Table 1[country])
RETURN
IF(SelectedCountry=1,Format([Measure1],"£0.00"),Format([Measure1], "$0.00"))I have tried using various filters but have had no success. Any ideas? :)
I'm not quite sure I understand. You want to only return the average if the price is not blank? If that's the case, you can either use a visual filter or inside your measure do something like this:
CALCULATE(AVERAGE(Table1[Price]), Table1[Price] <> BLANK())
3 Replies
It's working for me:
MyMeasure = var avgPrice = AVERAGE(Table1[Price]) var SelectCountry = SELECTEDVALUE(Table1[Country]) Return IF(SelectCountry = 1, FORMAT(avgPrice, "£0.00"), FORMAT(avgPrice, "$0.00"))
I'm not quite sure I understand. You want to only return the average if the price is not blank? If that's the case, you can either use a visual filter or inside your measure do something like this:
CALCULATE(AVERAGE(Table1[Price]), Table1[Price] <> BLANK())
