Forum Discussion

Fcoatis's avatar
Fcoatis
Post Patron
7 years ago
Solved

Distinct from a virtual table

Hello,

 

I need to create a distinct value with no blanks table from this:

 

    SELECTCOLUMNS(
        CALCULATETABLE(
            Arbitragem,
            Arbitragem[Função]="Arbitro",
            Arbitragem[Nome Oficial]<>" "
        ),
        "Arbitro", Arbitragem[Nome Oficial]
    )

Please help

Need Help
  • SteveCampbell's avatar
    SteveCampbell
    7 years ago

    In Dax, this table can be created by:

     

     

    Arbitro = 
CALCULATETABLE(
    VALUES(Arbitragem[Nome Oficial])
    ,TRIM(Arbitragem[Nome Oficial]) <> BLANK() 
    ,Arbitragem[Função]="Arbitro"
)

     

     

    Love hearing about Power BI tips, jobs and news?
    I love to share about these - connect with me!

    Stay up to date on  
    Read my blogs on  

    Remember to spread knowledge in the community when you can! 

     

2 Replies

  • SteveCampbell's avatar
    SteveCampbell
    Memorable Member
    7 years ago

    In Dax, this table can be created by:

     

     

    Arbitro = 
CALCULATETABLE(
    VALUES(Arbitragem[Nome Oficial])
    ,TRIM(Arbitragem[Nome Oficial]) <> BLANK() 
    ,Arbitragem[Função]="Arbitro"
)

     

     

    Love hearing about Power BI tips, jobs and news?
    I love to share about these - connect with me!

    Stay up to date on  
    Read my blogs on  

    Remember to spread knowledge in the community when you can! 

     

    • Fcoatis's avatar
      Fcoatis
      Post Patron
      7 years ago

      @stevecampell Thank you very much!