Forum Discussion
Resolver IIIReplacing blank with Zero : Matrix
Hello,
How to replace blank with zero in Matrix. Kindly note I am not using Dax to get values.
Sample Data: Pbix
Regards,
Chandrashekar B
Chandrashekar , we usually add +0, to measure. Yet to check the file
7 Replies
- amitchandak
Super User
Chandrashekar , we usually add +0, to measure. Yet to check the file
ChandrashekarHello Amit,
am not using dax however using fields directly into visisuals.
Regards,
Chandrashekar B
- amitchandak
Chandrashekar , Refer to the attached file after signature, it requires model change and measure
Hi @Chandrashekar ,
Depending on your description, you want to replace the white space in the matrix with 0.
Here are my steps you can follow:
(1)This is my test data.
(2) Create a measure [MEASURE2].
Measure 2 = DIVIDE( AVERAGE(Sheet1[Score]), CALCULATE(AVERAGE(Sheet1[Score]),ALLEXCEPT(Sheet1,Sheet1[A1/A2])) ) + 0(3) Then we can meet your need , the result is as follows.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Chandrashekar
Hello,
Thanks it is working perfectly 🙂
Regards,
Chandrashekar B
