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.
Hello,
I am currently have an issue with count/countrows. When they evaluate and return nothing it shows blank instead of 0.
I have 2 tables, a calendar table and a fact table with 10 rows.
I am trying to calculate the percentage of colum ORIT = "Y".
Lines ORIT2 =
var _orit = CALCULATE(COUNTROWS(dataVN),dataVN[ORIT]="Y")
return if(ISBLANK(_orit),0,_orit)
The result is this. I don't want those extra lines that mean nothing.
The manufacturing data field comes from the calendar table.
How can I avoid this situation and get the desired result?
The .pbix file is in this link if you want to try - https://we.tl/t-bHGwtdUf5d
Thank you.
André
Solved! Go to Solution.
Hi @afbraga66
Please try https://www.dropbox.com/t/Fm7RwOsIaqz2Duog
Lines ORIT2 =
IF (
NOT ISEMPTY ( dataVN ),
COALESCE ( CALCULATE ( COUNTROWS ( dataVN ), dataVN[ORIT] = "Y" ), 0 )
)
CALCULATE(COUNTROWS(dataVN),dataVN[ORIT]="Y") + 0
Hi @afbraga66
Please try https://www.dropbox.com/t/Fm7RwOsIaqz2Duog
Lines ORIT2 =
IF (
NOT ISEMPTY ( dataVN ),
COALESCE ( CALCULATE ( COUNTROWS ( dataVN ), dataVN[ORIT] = "Y" ), 0 )
)
HI @tamerj1 , It works thank you so much! Still, I'm intrigued on what is the role of ISEMPTY() and why without it, it doesn't work. Could you explain, please? Thank you.
If the table itself is empty in the current filter context then you need to keep the result blank. You need to have it zero if only the filtered table by CALCULATE is blank. Just pay attention to the difference between the original table and the filtered table.
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
46 | |
39 | |
19 | |
19 |