cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BI007
Regular Visitor

Calculated Column


Hello. I'll explain my problem, hope somebody will help: I have 3 Tables "Countries", "CityData" and "Finaltable".
"Countries" and "CityData" are related by city column.

As you see, there is a filter on "Filters on all pages" pane - "City" column from "Citydata" table.

BI007_0-1665173617529.png

 

I need, in third "Finaltable" table, in calculated column "Column2 Amount" to be shown the corresponding amount of selected (filtered) city.

for instance, if on "Filters on all pages" pane there is selected Milan, then 

BI007_3-1665173265794.png

 if on "Filters on all pages" pane there is selected London, then 

BI007_4-1665173333063.png

I need calculated column "Column2 Amount" and not Measure.
There will not be be more than 1 value selected in on "Filters on all pages" pane.

Thanks in advance

 

2 REPLIES 2
lukiz84
Memorable Member
Memorable Member

Hi,

 

why do you need a calculated column?

 

It doesn't work. Calculated columns are calculated during refresh of the data model and don't have a filter context.

 

This means that you can't change the value of a calculated column with slicers.

Thanks for reply. In real project, where I need the solution, peple are connected to this data model, with excel files and they are using "Column2 Amount" in tables and matrix visuals, as rows:

BI007_0-1665239738379.png

 

Besides, it's necessary to use "Column2 Amount" as filters. How can it be done?
Can't I create KPI, and than than use the values of KPI in calculted column?

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors