DAX Fridays!

[@arklur3193]

One thing to add: since it's a logical column, you don't even have to write the "=" part of it, you can simply just write the column name, e.g. "CaptersReviwed = CALCULATE ( COUNTROWS ( Reviewed ); Reviewed[Reviwed?] )", and it would still work :).

[@CurbalEN]

Yes! Why didn’t I think of that !? Pinned comment so others see it :) Thanks for sharing! /Ruth

[@andrewalfred3473]

If you want go 1 more step and find true percenrage ?how will we do

[@AnalyzeIt_Nael]

Thank for the tip. I also see why you are using counta instead of count as the later doesn't work with logic column

[@CurbalEN]

Sometimes you have to do wrong to know what’s right ;) /Ruth

[@lifeisstr4nge]

1 and 0 are also interchangeable for true false in PBI

[@CurbalEN]

Are they? No idea! Thanks for sharing ! You guys are awesome! /Ruth

[@franciszambrano4954]

I can not download the files from Download center Curbal. I'm from Ecuador. Thank you.

[@CurbalEN]

Yes, sorry Francis, but my servers are down and I am on holidays. They will be up again on Tuesday. Apologize for the inconvenience ! /Ruth

[@franciszambrano4954]

@@CurbalEN ok thanks :)

[@nazarkamal8831]

Very useful ❤❤❤

[@pabeader1941]

So here's a question. Are true (as a keyword) and True() (as a function) the same thing???

[@CurbalEN]

Technically no, but in this case they do the same thing. /Ruth

[@김차수-k2u]

Have nice easter !!! Thank you foy your explanation for True, false

[@CurbalEN]

Same to you! :) /Ruth

[@christopherhastings2142]

Great example! The error message that you got was amusing!

[@CurbalEN]

😂😂 I find all power bi errors amusing somehow, or is it confusing? ;)/Ruth

[@bradj229]

Thanks! If you do decide to ever right a book, I'll buy and read it :)

[@CurbalEN]

Thanks :) No time for that at the moment

[@joaovictordemedeirosbarbos8453]

That’s Great!!! Thank U so much!

[@nalinhettiarachchi8356]

This is great!

[@belizatube]

Always helpfull, Ruth! Thank you!

[@CurbalEN]

Glad it was helpful :) and happy Easter! /Ruth

[@rexson75]

Thank you for sharing, helpful content :-)

[@CurbalEN]

Yey!! 🥳🥳

[@shadowitself]

so true ;) thanks

[@CurbalEN]

😂

[@nazarkamal8831]

❤❤❤

[@kabirpatil7739]

Your content is really good but if you skip your stories it will be much more professional and time-saving

[@CurbalEN]

Life is full of stories, what would we be without them?