Forum Discussion

Brian874's avatar
Brian874
Frequent Visitor
4 years ago
Solved

DAX Help with VAR Measurement

I have a table called rating and trying to add a measure for the total number of leads however cannot currently do this. I am very new to Power BI and would be very grateful for the help    
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Brian874 , Try a measure like

    Countrows(Filter(Table, search("Non-Lead",Table[Column],,0)= 0 && search("Lead",Table[Column],,0) > 0 ) )

Arul's avatar
Arul
Super User
4 years ago

Brian874 ,

Try the below approach,

1. Create a calculated column,

Rating Left = LEFT(Rating[Rating],SEARCH(":",Rating[Rating])-1)

2. Then create a measure using the below formula,

Count of Lead = CALCULATE(COUNTA(Rating[Rating Left]),Rating[Rating Left]="Lead")

 

Thanks,

Arul