Forum Discussion
Count formula
Hi timward10 ,
Firstly make sure the data type of your columns is whole number.
Then you can create a Table visualization and add columns you need with Count Function.
Power BI will show blank if there is no data.
If you want to show 0 instead of blank, you need to create 12 measures due to your data model.
The measures are similar, they look like as below.
Count Number Jan 25 = CALCULATE(COUNT('Table'[Total Rev Jan 25]))+0...
Result is as below.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Table is attached, I would expect to see all of them columns return zero, apart from the ones that have numbers in, they would return one and so on.
What fields are you referencing in your formula?
Thanks
Hi timward10 ,
Firstly make sure the data type of your columns is whole number.
Then you can create a Table visualization and add columns you need with Count Function.
Power BI will show blank if there is no data.
If you want to show 0 instead of blank, you need to create 12 measures due to your data model.
The measures are similar, they look like as below.
Count Number Jan 25 = CALCULATE(COUNT('Table'[Total Rev Jan 25]))+0...
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Perfect Anonymous! It was just the formula I was looking for, if I add the columns together this works how I need it to! Thank you!