Forum Discussion

lucas105's avatar
lucas105
Icon for Advocate II rankAdvocate II
6 years ago
Solved

Measure to behave differently on specific level

Hi again,    I come with another problem I struggle to figure out.    I prepared a .pbix file with small data set to help figure out, but I can't seem to attach it here so I'll add it in the comm...
Need Help
  • lucas105's avatar
    lucas105
    6 years ago

    I solved this thing quite differently to be honest as I wasn't able to replicate your solution. 

     

    What I did was introduce some new empty rows to my dimension table with specific attirbutes and negative ids I wanted to see (there were 7 of them, so didn't really make a difference) and used something like:

    SUMX(FILTER('Dim Table', [id] < 0), 
           CALCULATE(sum([value]), FILTER(ALL'Dim Table', [Column] = SELECTEDVALUE([Column]) && [FLAG] = 1) 
          )

     

    Worked out for me, so really hope that also can help anyone out 🙂

     

    Best, 

    Luc 

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi lucas105 ,

 

Please try the following steps.

1# Right-click Category and Type and click New group and create a new group "All".

2# Create a calculated column.

Column = IF('Table'[flag]=0,"Allother",'Table'[Supplier])

3# Create a Matrix visual.

 

Best Regards,

Jay

Community Support Team _ Jay Wang

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

  • lucas105's avatar
    lucas105
    Icon for Advocate II rankAdvocate II
    6 years ago

    I solved this thing quite differently to be honest as I wasn't able to replicate your solution. 

     

    What I did was introduce some new empty rows to my dimension table with specific attirbutes and negative ids I wanted to see (there were 7 of them, so didn't really make a difference) and used something like:

    SUMX(FILTER('Dim Table', [id] < 0), 
           CALCULATE(sum([value]), FILTER(ALL'Dim Table', [Column] = SELECTEDVALUE([Column]) && [FLAG] = 1) 
          )

     

    Worked out for me, so really hope that also can help anyone out 🙂

     

    Best, 

    Luc