Forum Discussion

3s's avatar
3s
Regular Visitor
7 months ago
Solved

No results

Hi, I am new in here and in Dax. I couln't find a similar question, so hopefully someone can help. I am trying to achieve the same as Excel: countif(B:B;B2;A:A;D2). This is what I am doing: Count...
Need Help
Show and Tell
Tips and Tricks
  • krishnakanth240's avatar
    krishnakanth240
    7 months ago

    Hi 3s 

     

    Have tried this in desktop with your sample data. Please let me know the exact requirement/logic if it does not work.

     

     

  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 months ago

    Hi,

    These calculated column formulas work

    =CALCULATE(COUNTROWS(Data),FILTER(Data,Data[member]=EARLIER(Data[member])&&Data[year]=EARLIER(Data[year+1])))+0

     

    =CALCULATE(COUNTROWS(Data),FILTER(Data,Data[member]=EARLIER(Data[member])&&Data[year]=EARLIER(Data[year-1])))+0

    Hope this helps.

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
7 months ago

3s 

maybe you can try this to create a calculated column.

 

Count =
CALCULATE(
COUNTROWS('Table'),
FILTER(
'Table',
'Table'[ID] = EARLIER('Table'[ID])
&& 'Table'[Year] = EARLIER('Table'[Year])
)
)

 

if this does not work, could you pls provide some sample data and expected output?

could you pls provide some sample data and expected output?