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.
I have one column amount. and i am adding measure sum(amount) in matrix. but for some row column combination it is displaying blank so i want to replace those blank with zeros.
I tried measure
measure=sum(amount)
final amount=if(isblank(measure),0,measure)
but it is unnecessarily displaying columns which has no data. is there any way so that we will have those columns only which has valid data and replace blank with zeros.
adding zero in measure also leads to same result which i have shared. i want same functionality of power BI matrix visula which don't show unnecessary columns even if they are in range.
I want to remove those columns has total 0(if i have not replaced blank with zeros i am getting expect result but our clients want zero instead of blanks).
above measure is syntactically wrong.
i have modified it
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |