Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have the following code that shows the number of issues were the control name is not blank. This works correctly. But now I need to have it the other way around, so it should count if there is not a link, so the Control name is blank. I thought I could do this by changing the 'not(isblank' to 'isblank'. But then I get no results. Is there something I do wrong in this code?
Working, not blank calculation:
Solved! Go to Solution.
@Roym , It should work
Try like
M1 =DISTINCTCOUNT(Table_Issues[Name])
M2= sumx(filter( values(Table_Controls[Control Name]), isblank([M1])),[M1])
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
@Roym , It should work
Try like
M1 =DISTINCTCOUNT(Table_Issues[Name])
M2= sumx(filter( values(Table_Controls[Control Name]), isblank([M1])),[M1])
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
I got it working this way, thanks!!
User | Count |
---|---|
93 | |
86 | |
78 | |
72 | |
66 |
User | Count |
---|---|
115 | |
106 | |
85 | |
65 | |
64 |