Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
98 | |
90 | |
84 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |