Power BI Dax function

[Anonymous]

Hi 

I need help for Dax function .I need to count false and ture value From column.Please refer below image.

Column name discontiuned how many true and false discontiuned count.

Thanks In advance.

[v-qiuyu-msft · Accepted solution]

Hi @Anonymous, 

You can create measures below: 

CountTrue = CALCULATE(COUNTA('Table'[discontiuned]),FILTER(ALLSELECTED('Table'),'Table'[discontiuned]=TRUE()))

CountFalse = CALCULATE(COUNTA('Table'[discontiuned]),FILTER(ALLSELECTED('Table'),'Table'[discontiuned]=FALSE()))

Best Regards,
Qiuyun Yu