Forum Discussion

rutujakadam_11's avatar
rutujakadam_11
Frequent Visitor
2 years ago
Solved

One column in a matrix should not interact with Slicer

I have a power bi report of finance domain which consist of matrix. In the rows field I have various Entity names of the company and for values I have created various DAX to calculate revenue generat...
Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    rutujakadam_11 , Try if one of the two can help

     

    MTD = TOTALMTD(
    SUM('vw_SXIRev_OST'[Converted_USD]),
    'vw_Date_Dimension'[DateKey - Copy],
    FILTER(
    (vw_SXIRev_OST),
    (vw_SXIRev_OST[Acc_Type] = "Sales" || vw_SXIRev_OST[Acc_Type] = "Daily") &&
    vw_SXIRev_OST[Scenario] = "Actual"
    ), all(vw_SXIRev_OST[Acc_Type]), all(vw_SXIRev_OST[Scenario])
    )


    MTD = calculate( TOTALMTD(
    SUM('vw_SXIRev_OST'[Converted_USD]),
    'vw_Date_Dimension'[DateKey - Copy]) ,
    FILTER(
    all(vw_SXIRev_OST[Acc_Type]),
    (vw_SXIRev_OST[Acc_Type] = "Sales" || vw_SXIRev_OST[Acc_Type] = "Daily") ),
    FILTER(
    all(vw_SXIRev_OST[Scenario]),
    vw_SXIRev_OST[Scenario] = "Actual"
    )
    )

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

rutujakadam_11 , Try if one of the two can help

 

MTD = TOTALMTD(
SUM('vw_SXIRev_OST'[Converted_USD]),
'vw_Date_Dimension'[DateKey - Copy],
FILTER(
(vw_SXIRev_OST),
(vw_SXIRev_OST[Acc_Type] = "Sales" || vw_SXIRev_OST[Acc_Type] = "Daily") &&
vw_SXIRev_OST[Scenario] = "Actual"
), all(vw_SXIRev_OST[Acc_Type]), all(vw_SXIRev_OST[Scenario])
)


MTD = calculate( TOTALMTD(
SUM('vw_SXIRev_OST'[Converted_USD]),
'vw_Date_Dimension'[DateKey - Copy]) ,
FILTER(
all(vw_SXIRev_OST[Acc_Type]),
(vw_SXIRev_OST[Acc_Type] = "Sales" || vw_SXIRev_OST[Acc_Type] = "Daily") ),
FILTER(
all(vw_SXIRev_OST[Scenario]),
vw_SXIRev_OST[Scenario] = "Actual"
)
)

rutujakadam_11's avatar
rutujakadam_11
Frequent Visitor
2 years ago

I have prepared the DAX fo MTD & PriorYearMTD using (ALL) function for the requirement that they should not interact with Scenario Slicer. But now I want to create a third column which is the difference between MTD-PriorYearMTD. I am trying to do this calculation using the MTD & Prior Year MTD DAX but this column is now interacting with slicer. 

As I have used the ALL function to both DAXs, should'nt the result column perform similar output of not interacting with slicer?