Forum Discussion
Replace value of Matrix columns
Anonymous Are you saying you need to do this in Power Query when ingesting the data or in a Matrix visual? If in a visual, create a measure like Measure = IF(MAX('Table'[Value])=999.90,0,MAX('Table'[Value]))
Hi Anonymous ,
You can update the formula of measure as below:
New measure = IF ( [original measure] >999, 0, [original measure] )If the above one is not working for your scenario, please provide your sample pbix file (exclude sensitive data) if it is possible. Later we will provide you a suitable solution base on your sample file. Thank you.
Best Regards
Hi Anonymous
and Greg_Deckler
If I will use
New measure = IF ( [original measure] = 999.90, 0, [original measure] )
this command, it will fail because the value is 999.9000244140625...
IS there a similar command saying if value >999, then make it zero ?
Kind Regards,
Antonios Katsikinis
Hi Anonymous ,
You can update the formula of measure as below:
New measure = IF ( [original measure] >999, 0, [original measure] )If the above one is not working for your scenario, please provide your sample pbix file (exclude sensitive data) if it is possible. Later we will provide you a suitable solution base on your sample file. Thank you.
Best Regards
Hi Anonymous,
That's perfect. Thanks.
I just created a test report, but I can see that my organisation is preventing me from sharing it outside of the company.
It is a matrix with up to 2 million lines which are consantly increasing, and 75 columns from which 28 contain data with this value.
Do you still suggest to try and converting the multiple value fields in Power Query and then unpivot ?
Kind Regards,
Antonios Katsikinis