Forum Discussion

kancs9128's avatar
kancs9128
Frequent Visitor
2 years ago

Relationship between two different visuals (inside the same page).

Hi all; Need help. Currently, the visuals below is showing Sum of Inventories filtered by Mth End Close (Month End Close) & Corporate BU (Business Units). Mth End Close: months eg; Jul2023, Aug202...
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi kancs9128 

 

Please try the following DAX:

Inventory  = 
    IF(
        ISFILTERED('Date'[Month End Close]) && 
        SELECTEDVALUE('Date'[Month End Close]) = "ALL", 
        BLANK(), 
        SUM('Inventory'[Inventories])
    )

 

This measure will check if the "Month End Close" filter is set to "ALL" and, if so, return blank; otherwise, it will sum the inventories.

 

 

 

 

 

Best Regards,

Jayleny

 

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

kancs9128's avatar
kancs9128
Frequent Visitor
2 years ago

Hi - "Month End Close" filter is set to "ALL" 

but then, when applying the formulae - still unable to get Blank ().