Forum Discussion

jasonyeung87's avatar
jasonyeung87
Icon for Helper V rankHelper V
6 years ago

Filtering data based on 2 columns in dataset

Hi,   I'm using the table visualization to display data from an analysis services database. The data looks similar to the following: Customer Name User Name Jason Jay John John Juli...
Need Help
v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi  jasonyeung87 ,

 

You can create a report level measure in live connection mode,such as :

measure=IF(MAX('table'[Customer Name])<>MAX('table'[User Name])&&MAX('table[User Name])<>BLANK(),MAX('table'[Customer Name]),BLANK())

Put measure with column [User Name],you will see your expected output.

Below is the reference:

https://radacad.com/live-connection-when-power-bi-comes-hybrid#:~:text=Modeling%20and%20Report%20Level%20Measure,for%20this%20Power%20BI%20report.

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
  • jasonyeung87's avatar
    jasonyeung87
    Icon for Helper V rankHelper V
    6 years ago

    Hi Kelly,

     

    The New measure button is greyed out for me. Is there a way to activate this button?

     

    Sincerely,

     

    Jason