Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Count IF / 'Set Analysis'

Hi All,  Just started a new job where they use Power BI, having used Qlik in the past I am having trouble with getting the correct outputs.    If I consider the table below      ideally I...
Tips and Tricks
v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, Anonymous ;

You could modify it.

Measure = DIVIDE( COUNT([count]),CALCULATE(COUNT([count]),FILTER(ALL('Table'),[Month]=MAX([Month])&&[Vendor]=MAX([Vendor]))))

The final output is shown below:

 


Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.