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 ) )

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    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