Forum Discussion
Dax expression
Hi How to write DAX Expression in matrix table having multiple columns, in that we have two or three columns having blank vlaues , then remaining column which is having data should display color ...
Anonymous if you have blank values and you can add +0 at the end of your measure ie sum(columnname) + 0 or you can do an if(isblank(columnname),0,columnname)
for conditional formatting in the matix object use condition formatting and look at the different options according to your requirements in the settings
Hi
country A B C
India 1 2 3
USA 8 3
UK 4 9
AUS 8 4 5
Above some data is blank in USA and UK columns , My scenario in USA 'A' is blank , USA B and C having values. The values which are showing B is 8 and C is 3 in USA should display any some color. How to write DAX Expression for this. Please help it.
Thanks
sreenivasa