Forum Discussion

Roym's avatar
Roym
Helper IV
4 years ago
Solved

CountIF value is

I have a table in my dataset that has a column with the Frequency that could be either be Annual, Quarterly, or Periodical. Now I want to count the number of annual issues and Quarterly issues. It sh...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago
    So is it correct that you can only use these measures in your report and not in the dataset?

    No. It's possible to write calculated columns that work but you need to be more careful. Please read the articles I linked for more detail.

     

    Measure are probably the best choice in this case anyway though. More detail on the difference here:

    https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

parry2k's avatar
parry2k
Super User
4 years ago

Roym you should add these as a measure instead of the column and that will do it. To learn more about circular dependency, there is a great article on SQLBI website, just google for it.

 

✨ Follow us on LinkedIn

 

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡