👉 👉 This video shares 2 methods to calculate distinct numbers when ONE or multiple criteria is met. We'll also explain in detail one of the common error faced by beginners in creating calculated fields in Data Studio. You may replace the COUNT_DISTINCT formula with COUNT(), or IF() formula with CASE_WHEN() formula based on your use case. The fundamental concept is the same once you understand how it works in Google Data Studio. (Timestamp provided below if you wish to revisit certain chapters) Does this tutorial helpful? Lemme know in the comment below 👇👇👇 F R E E B I E S I used Canva to make graphics for my education videos and thumbnails. If you want to try this amazing tool, you are welcome to use the link below! Try Canva Pro FREE for 30 days: [ This is an affiliate link. I receive a small commission if you decided to subscribe to the Canva plan after trying it out. There's no extra cost to you.] 𝐖𝐚𝐧𝐭 𝐭𝐨 𝐬𝐮𝐩𝐩𝐨𝐫𝐭 𝐦𝐨𝐫𝐞 𝐜𝐨𝐧𝐭𝐞𝐧𝐭 𝐥𝐢𝐤𝐞 𝐭𝐡𝐢𝐬 ? 👉 You can now buy me a coffee @ 👉 Subscribe to my channel @ #Google #DataStudio #Tutorial #Date -------------------------------------------------------------------------------------------------------------------------- ⏰ Content Outline ⏰ ⏩ 0:00 Dataset Overview and Example ⏩ 01:15 Method #1 : Simple and Easy ⏩ 02:54 When to use method #2 ? ⏩ 03:06 Error Message Explained + Error Debug ⏩ 05:22 Method #2 ** Blog Post: 📘 Google Data Studio Formula Documentation: ‣ COUNT_DISTINCT - ‣ IF- ‣ CASE WHEN - -------------------------------------------------------------------------------------------------------------------------- 👧🏻 The person behind this channel is a Malaysian-Chinese Data Analyst. Aspired to create content for non-technical background audiences to up their game in their careers or even for students to prepare for their future career at early stages. 🌱 Learn something today and want to learn more? 👧🏻 SUBSCRIBE NOW 👉 👧🏻 FOLLOW ME on TWITTER for more content (some content are exclusive to Twitter) 👉 --------------------------------------------------------------------------------------------------------------------------- 💌 MY SUGGESTED VIDEO FOR YOU: ⚈ How to work with timestamps in Data Studio? 👉 ⚈ Export Data from Data Studio 👉 ⚈ Automation in Data Studio (Email Delivery) 👉 ⚈ Master Filter in Data Studio 👉