Forum Discussion

ybicalways79's avatar
ybicalways79
Frequent Visitor
3 years ago

DAX Measure to filter Multiple DataSets in Visuals - Power Bi

Ive been at this a week now with little progress and lot of frustration.   I have 2 slicers is my projects which are both shows here in the left corner.  When I select a Visual Category, I would li...
"Power BI"
DAX
SELECTEDVALUES
Slicer
sum
Visuals
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi ybicalways79 ,

 

I suggest you to remove or inactive the relationship between two tables. Then create measures to get result.

Select Category Price = 
VAR _SELECTEDALUE =
    SELECTEDVALUE ( 'Visual Category'[SalesRounteMatch] )
RETURN
    IF (
        ISFILTERED ( 'Visual Category'[Matched Categories] ),
        IF (
            _SELECTEDALUE = BLANK (),
            CALCULATE ( SUM ( Sales[Price] ) ),
            CALCULATE ( SUM ( Sales[Price] ), Sales[Route] = _SELECTEDALUE )
        )
    )

Result is as below.

 

Best Regards,
Rico Zhou

 

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