Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi
I have a simple data table with years (Anno) ranging from 2021 to 2023
I have created two tables just with the list of years
f_start = summarize(Dati,Dati[Anno])
f_end = summarize(Dati,Dati[Anno])
I want to create a table like this
Where, corresponding to each Segment, I have the sum of all the values from the selected Start year and from the End year
Now, if I build a new table like the following it returns me a blank table:
TabStarEnd =
var s_start=selectedvalue(f_start[Anno])
var s_end=selectedvalue(f_end[Anno])
return
ADDCOLUMNS(
SUMMARIZE(
Dati,
[Segmento]
),
"Start",CALCULATE(
SUMX(filter(Dati,Dati[Anno]=s_start),Dati[Ordinato])
),
"End",CALCULATE(
SUMX(filter(Dati,Dati[Anno]=s_end),Dati[Ordinato])
)
)
Instead, if I force "2021" and "2023" in s_start and s_end respectively it works (and gives the result I have shown before)
Why is function SELECTEDVALUE not working?
Thanks
Fabrizio
Solved! Go to Solution.
Slicers don't affect calculated columns or tables.
---
You could create 2 measures and use them in a table visual to get what you want.
Slicers don't affect calculated columns or tables.
---
You could create 2 measures and use them in a table visual to get what you want.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |