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 thought this was straight forward you just add +0 to the DAX as it add zero values to balnk cells.
Here is my DAX formula i want to zero data points not as blank but 0 as shown in the image they are current empty cells.
IMAGE
DAX
PMSComplaintsMN = CALCULATE(IF(ISBLANK(COUNTA('PMS_COMPLAINT'[MATERIAL_ID])),BLANK(),COUNTA('PMS_COMPLAINT'[MATERIAL_ID])), ALLSELECTED(PMS_FINANCIAL_PDS[ROLL12_COMPLETE_PDS_IND]))
Solved! Go to Solution.
@Anonymous
PMSComplaintsMN = CALCULATE(IF(ISBLANK(COUNTA('PMS_COMPLAINT'[MATERIAL_ID])),0,COUNTA('PMS_COMPLAINT'[MATERIAL_ID])), ALLSELECTED(PMS_FINANCIAL_PDS[ROLL12_COMPLETE_PDS_IND]))
Try this!
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Proud to be Datanaut!
@Anonymous
PMSComplaintsMN = CALCULATE(IF(ISBLANK(COUNTA('PMS_COMPLAINT'[MATERIAL_ID])),0,COUNTA('PMS_COMPLAINT'[MATERIAL_ID])), ALLSELECTED(PMS_FINANCIAL_PDS[ROLL12_COMPLETE_PDS_IND]))
Try this!
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Proud to be Datanaut!
Hi nsrshk1
add the 0 in the place or Blank(), throws my graph out. see images.
Image below is correct 100% (with) blank in dax
Image 2 when blank is replaced with 0
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 |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |