Forum Discussion
Count IF Power Bi
Trying to create a count if function in power bi
Hi,
Does these measures work?
Average sale of all POG = calculate([Sales_avg1],all(POG[POG_Cluster]))
Measure = countrows(filter(values(POG[POG_Cluster]),[Sales_avg1]<[average sale of all POG]))
If this does not work, then share the link from where i can download your PBI file.
Anonymous I understand the logic but it is more important to understand the data. It is not all about sales and avg sales, the importance is to know how the relationship between tables is or using one table etc, etc. so do provide sample data with the expected output. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490