How is the master who can do this ?

[Jalil239]

Here is DAX 

Total Average only = IF(ISFILTERED(OTOnline[OT_Month]), BLANK(), [Average_OT_Per_48])

I dont want red X one just only Green tick 

[v-nuoc-msft · Accepted solution]

Hi @Jalil239 

Many thanks to danextian , mianjalil239 and dharmendars007  for their prompt reply. Let me add something here.

You may not be able to do this in the default design of power bi desktop, but let's try something else:

Solved: Matrix - Hide a column in visual but consider in c... - Microsoft Fabric Community

As mentioned in this post, you can turn off "Text wrap" in "Values" and "Column headers" and do this by adjusting the width.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mianjalil239]

https://community.fabric.microsoft.com/t5/Desktop/How-is-the-master-who-can-do-this/m-p/4163748#M131...

[mianjalil239]

https://community.fabric.microsoft.com/t5/Desktop/How-is-the-master-who-can-do-this/m-p/4163748#M131...

[mianjalil239]

https://community.fabric.microsoft.com/t5/Desktop/How-is-the-master-who-can-do-this/m-p/4163748#M131... 

[danextian]

Hi @Jalil239 

 Trying to hide a measure in the matrix viz hides all measures for that related column altogether.
What  you are trying to achieve requires a disconnected table that contains the desired column as value placeholders and then a measure to show the desired values. 

Please see attached sample pbix.

[Jalil239]

Not working I want OT monthly but OT Average for the year not month wise ! 

[dharmendars007]

Hello @Jalil239 , 

Please try the below code using HASONEVALUE ensures that a value is only returned if there is exactly one value selected in the OT_Month column.

Total Average only =
IF(HASONEVALUE(OTOnline[OT_Month]),[Average_OT_Per_48],BLANK()) 

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!

Thank You

Dharmendar S

LinkedIN 

[Jalil239]

Not working I want OT monthly but OT Average for the year not month wise !