Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Microsoft Power BI Matrix - change individual cell value based on column total

I have a Power BI Matrix in which there are a number of measures. I have a lot of transaction level data at the back-end for each day in a month.   I have all the months in a Slicer, in which I ch...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

To create a measure as below.

Measure = 
VAR a =
    CALCULATE (
        SUM ( 'Table'[VALUE] ),
        FILTER ( 'Table', 'Table'[category] <> "B" )
    ) + 0
VAR b =
    CALCULATE (
        SUM ( 'Table'[VALUE] ),
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[category] = "C" )
    )
RETURN
    IF ( b <= 225, a, SUM ( 'Table'[VALUE] ) )

 

Pbix as attached.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks Frank, will get back

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hello Frank,

       

      The Matrix has only column groups; the Category column which you have assumed does not exist, i.e. there are no row groups in the matrix. There are a number of Measures (A,B,C,X,Y,Z) which are added as Values for the matrix.

       

      Let me know if this can be worked out.

       

      I tried using ISFILTERED at the day number level; but having some filter context challenges

      • v-frfei-msft's avatar
        v-frfei-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi Anonymous ,

         

        Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.