Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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!
Did I answer your question? Mark my post as a solution! Proud to be a Super User!
Connect with me!
Stay up to date on
Read my blogs on
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!
Did I answer your question? Mark my post as a solution! Proud to be a Super User!
Connect with me!
Stay up to date on
Read my blogs on
@stevecampell Thank you very much!