Forum Discussion
Solved
PowerPivOt and DAX counter
Hi I have a PowerPivot table, which consists of 3 tables in model which uses two main filters. Filter one column name is called 'Funded', the values in this column are either 'Yes', 'No' or 'bla...
Hi ChrisC365
You can try this formula might be helpful
MeasureCountYes:= COUNTROWS(FILTER(TableName,[ColumnName]="Yes"))MeasureCountNo:= COUNTROWS(FILTER(TableName,[ColumnName]="No"))If you are still facing issue please attached sample file to work on it and provide you appropriate solution, make sure to demonstrate your desired output in the sheets for better understanding.
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert | www.ExcelExciting.com
Hi ChrisC365
You can try this formula might be helpful
MeasureCountYes:= COUNTROWS(FILTER(TableName,[ColumnName]="Yes"))
MeasureCountNo:= COUNTROWS(FILTER(TableName,[ColumnName]="No"))
If you are still facing issue please attached sample file to work on it and provide you appropriate solution, make sure to demonstrate your desired output in the sheets for better understanding.
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert | www.ExcelExciting.com
Faraz
Many thanks, looking at my worksheet there is more happening with the filtering than I initially detailed. Its not that easy to paste a copy of similar data. Your formula works fine, this has made me realise I need to do a little more work my side. I will accept this solution and return at later date if I need help again.
Many thanks, looking at my worksheet there is more happening with the filtering than I initially detailed. Its not that easy to paste a copy of similar data. Your formula works fine, this has made me realise I need to do a little more work my side. I will accept this solution and return at later date if I need help again.
- Happy 😃 to hear solution working fine 👍
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert | www.ExcelExciting.com