topic Re: Selectedvalue in DAX Commands and Tips

Selectedvalue

Anonymous — Mon, 31 Mar 2025 07:53:44 GMT

Hi,

my visual table is always empty because of SelectedValue. I have 2 tables.

Table1: Filter

Group

Table2: Data

Customer	Group	Group_last_year
Alpha	A	A
Beta	A	B
Alpha	B	A
Gamma	C	C

My Measure:

SWITCH (
    TRUE (),
    SELECTEDVALUE ( Table1[Group] ) = "A",
        CALCULATE (
            DISTINCTCOUNTNOBLANK ( Table2[Customer] ),
            FILTER ( Table2, Table2[Group] = "A" && Table2[Group_last_year] = "A" )
        ),
    SELECTEDVALUE ( Table1[Group] ) = "A",
        CALCULATE (
            DISTINCTCOUNTNOBLANK ( Table2[Customer] ),
            FILTER ( Table2, Table2[Group] = "A" && Table2[Group_last_year] = "B" )
        ),
    SELECTEDVALUE ( Table1[Group] ) = "A",
        CALCULATE (
            DISTINCTCOUNTNOBLANK ( Table2[Customer] ),
            FILTER ( Table2, Table2[Group] = "A" && Table2[Group_last_year] = "C" )
        )
)

If I put Table1[Group] and my measure into a table in the visualization, it only shows me data for Group_last_year=A, but not for B and C. Is my measure wrong?

Thanks for any ideas.

Re: Selectedvalue

tharunkumarRTK — Mon, 31 Mar 2025 08:01:01 GMT

Anonymous

Not sure if I understand your requirement correctly, but one point that I observed is, all your switch conditions are same

SELECTEDVALUE ( Table1[Group] ) = "A"

By default DAX switch statement will evaluate the result of first condition which results to true value. So, I guess for your requirement you need to correct it.

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

Re: Selectedvalue

Cookistador — Mon, 31 Mar 2025 08:02:04 GMT

Indeed, in you measure you have = "A" everywhere

So only the first switch is used, I guess you have to replace the second SELECTEDVALUE ( Table1[Group] ) = "A", by B and the thirth by C

If it is not what you try to achieve, let me know

Re: Selectedvalue

Anonymous — Mon, 31 Mar 2025 08:08:32 GMT

Hi, yes indeed 🙂. My measure is only for Table1[Group]="A". I have another measure only for B and C.

Re: Selectedvalue

Anonymous — Mon, 31 Mar 2025 08:12:50 GMT

Hi, yes true. This measure is only for A. I have another measure only for B and C.

Re: Selectedvalue

Cookistador — Mon, 31 Mar 2025 08:21:03 GMT

But your measure for A is wrong, only the first case will be evaluated as you do not have other condition than Table1[Group] = "A"

What you should do is something like:

Mymeasure =

Switch(TRUE(),
Table1[Group] = "A",MeasureForA,
Table1[Group] = "B",MeasureForB,
Table1[Group] = "C",MeasureForC

)

Re: Selectedvalue

Anonymous — Mon, 31 Mar 2025 08:21:19 GMT

I want to count the customers from this year vs last year. How many customers in group A were in A last year, how many moved from A to B, ...

The visualzation should look like that:

	A last year	B last year	C last year
A	1	1	0
B	1	0	0
C	0	0	1

Re: Selectedvalue

Anonymous — Mon, 31 Mar 2025 08:23:54 GMT

so my measure is totally wrong for what I need 😣

Re: Selectedvalue

Cookistador — Mon, 31 Mar 2025 08:34:55 GMT

Show me in a table(Excel) what you are trying to achieve

I created a measure for A,B and C, and I got the following table

If you need to see the empty lines, you have to tick: Show item with no data

Re: Selectedvalue

Anonymous — Mon, 31 Mar 2025 08:53:59 GMT

Seems like I can't upload an excel file here "The file type (.xlsx) is not supported". So I have uploaded it online: https://uploadnow.io/f/YYfFPKk

Thank you so much for your help 🙏 Hope the excel makes it clear what I need

Re: Selectedvalue

Cookistador — Mon, 31 Mar 2025 09:12:52 GMT

In fact, you do not need dax to achive that
I just set up the following relationship

Then I added a matrix with the following parameters:

Rows: Group (if you need from filter)

Columns: group_last_year

Values: Count of CUSTOMER_NUMBER

The blank line is for D et E value

If you use everything for the excel file you shared

Re: Selectedvalue

Anonymous — Mon, 31 Mar 2025 09:20:42 GMT

Such a simple solution. It works. Thaaaaaaaaaaaanks so much 🌼