Forum Discussion

Morgana_2022's avatar
Morgana_2022
Icon for Helper I rankHelper I
4 years ago

table properties

Hi, it is possible to lock a column of a sample table view (like in excel)? Thanks to those who will help me.
Table
Table Visual
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi  Morgana_2022 ,

Here are the steps you can follow：

1. Create measure.

Category_Measure =
IF(
    HASONEVALUE('Table'[Title]),MAX('Table'[Category]),BLANK())
Prime_Measure =
IF(
    HASONEVALUE('Table'[Title]),MAX('Table'[Prime Personal.Subject]),BLANK())

2. Result:

If you need pbix, please click here.

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly