Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Count occurrence's of values using data slicer

Hi all,

I am working on data where I have to count distinct number of requests made by distinct number of accounts.
I need this calculation for one week 6/6/2021 to 6/12/2021. The implementaion works fine when I filter data seperately in new excel  file as shown below.

 

 

But same data does not show corect calculation when date slicer is applied for that week as below. It leaves out 8 and 9....
Why is it doing so?
I tried to replicate the countif of excel in power bi referring to threads from community. But the attempt was unsuccessful.

Any help ???

Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    5 years ago

    Hi, Anonymous 

     

    Please make sure you are performing the same operation in Excel and power bi. It is possible that there is no data in this date range as described above. Or maybe there is an error in your measures calculations. Because according to the screenshot provided above, the difference is not only in the missing 8 and 9 data, but also in the count of the other data is different. Please check your raw data and measure values. Or could you please consdier sharing more details about it or a simple sample file without any sesentive information for further discussion?

     

     

    Hope this helps.

     

    Best Regards,
    Community Support Team _ Zeon Zheng
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • v-angzheng-msft's avatar
    v-angzheng-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi, Anonymous 

     

    Please make sure you are performing the same operation in Excel and power bi. It is possible that there is no data in this date range as described above. Or maybe there is an error in your measures calculations. Because according to the screenshot provided above, the difference is not only in the missing 8 and 9 data, but also in the count of the other data is different. Please check your raw data and measure values. Or could you please consdier sharing more details about it or a simple sample file without any sesentive information for further discussion?

     

     

    Hope this helps.

     

    Best Regards,
    Community Support Team _ Zeon Zheng
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.