Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Selectedvalue

Hi,   my visual table is always empty because of SelectedValue. I have 2 tables.    Table1: Filter Group A B C Table2: Data Customer Group Group_last_year Alpha A ...
  • Cookistador's avatar
    Cookistador
    1 year ago

    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

     

  • Cookistador's avatar
    Cookistador
    1 year ago

    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

     

tharunkumarRTK's avatar
tharunkumarRTK
Super User
1 year ago

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!
  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

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