Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Experts
I am trying to count the number of blank values in my table based on another column
Created_Date | Closed |
14 August 2020 | 1 |
1 | |
23 July 2020 | 1 |
19 August 2020 | 1 |
1 | |
28 July 2020 | 1 |
1 | |
22 November 2019 | 1 |
20 August 2020 | 1 |
@Anonymous
Proud to be a Super User!
HI Vijay
I am getting blank result in score card....not the value 3
@Anonymous
Please find tjhe attached file
https://drive.google.com/file/d/1Knkn7OtNHejWJ1lllVDgQ9TN-cdrm4fI/view?usp=sharing
Proud to be a Super User!
@Anonymous , I was able to get 3 . Posted file in last update
Ok i forgot to mention my FACT Table TO DO links to a DIM Date table (1 to *) relationship Date to Created Date (FACT Table). i am still getting blank values???
@Anonymous ,
+0 to a measure and count zeros. Can you share the complete sample?
Hi AMit
I cannot upload a file nor send a drobox link. If you create a simple DIM Date Table and link DAte from Dim DAte to Created Date in FACT table and see if the measure works
@Anonymous
Then Formula will be calculate(countrows(facttable),filter(all(datestable),isblank(datesinfacttable))
Proud to be a Super User!
@Anonymous , Try like
countrows(filter('STG Fact_To_Do', isblank(Created_Date)))
or
calculate(countrows('STG Fact_To_Do'),filter('STG Fact_To_Do', isblank(Created_Date)))
Both DAX formula return back blank as oppsed to the value 3
@Anonymous , Please find the find attached after signature
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
103 | |
101 | |
76 | |
66 | |
60 |
User | Count |
---|---|
142 | |
106 | |
103 | |
85 | |
70 |