Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

slicer

buenas tardes, en este modelo tengo varios elementos como son tuberias y conexiones. Ahora bien, para yo poder pagarle al contratista por los trabajos ejecutados, tengo 4 columnas, 2 de ellas pertenc...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Anonymous 

    I have a short sample to demonstrate display the column value based on the selected column name. 

     

    1. Manually enter the column names in a new table.

     

    2. Create a measure to display selected column value.

    Install 50/100 = SWITCH(MAX('Table (2)'[Install %]),
    "INSTALLED 50%", SUM([INSTALLED 50%]),
    "INSTALLED 100%",SUM([INSTALLED 100%]))
     

     

    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Anonymous 

I have a short sample to demonstrate display the column value based on the selected column name. 

 

1. Manually enter the column names in a new table.

 

2. Create a measure to display selected column value.

Install 50/100 = SWITCH(MAX('Table (2)'[Install %]),
"INSTALLED 50%", SUM([INSTALLED 50%]),
"INSTALLED 100%",SUM([INSTALLED 100%]))
 

 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.