Hide monthly values for one column in Matrix but keep subtotals and totals visible

[GanesaMoorthyGM]

Hi Team,

I'm back once again in need of better formatting visuals:

So I partially achieved the goal:

Now What I'm looking to execute is You can see the stock turn column which shows value for every month, but instead of showing for every month i'm okay with showin only the subtotal for that (Stock Turn) and dont show value for each month whereas the other 2 column should show values each month is this possible?

If YES, Guide me through I'm expecting like


And this is my Stock Turn Measure:

Stock Turn =

DIVIDE(

    [Total Sales Value in Cr stock],

    [Average Stock Value in Cr FSM],

    BLANK()

)

[xifeng_L · Accepted solution]

Hi @GanesaMoorthyGM,

You can try below measure:

Stock Turn =
IF(NOT ISINSCOPE(Calendar[MonthName]),
    DIVIDE(
        [Total Sales Value in Cr stock],
        [Average Stock Value in Cr FSM],
        BLANK()
    )
)

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~

[GanesaMoorthyGM]

Thank You @xifeng_L ,

With Slight Modification I achieved this using..

Stock Turn (Display) =

VAR _isMonth = ISINSCOPE('Dim_Month'[MonthName])  

RETURN

IF(

    _isMonth,

    BLANK(),          

    [Stock Turn]        

)