cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Resolver I

## 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? 🙂

1 ACCEPTED SOLUTION
Memorable Member

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 3
Memorable Member

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"))```

Resolver I

@hnguy71 thanks for helping 🙂 unfortunately it's still not working for me, having tried a few different things. The only reason I can think of is because of blanks in my Price column?

Memorable Member

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())`

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

#### Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors