Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX Measure from Excel Formula

Hi, Would someone know how I can convert my Excel formula to DAX? It's already 2 weeks, I tried every COUNT formula in PowerBI but no luck. Any suggestion is appreciated. Thank you!   =COUNTIFS('S...
DAX
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , it would something like

    countx('Scorecard-All', if('Scorecard-All' [H]>.03 && 'Scorecard-All'[C] > time(,2,0)),'Scorecard-All'[J] )/count('Scorecard-All'[J] )

     

    Can you share sample data and sample output in table format?