Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi ,
How to summation only which starts with NG_ and that summation should be shown in NG_GYM
Iam using matrix visual in power bi exposure column was created by using dax measure
Expos = CALCULATE(SUM('TA Expos'[expo]),USERELATIONSHIP('Calendar'[Date],'TA Expos'[Trading_Period_date]))
Note:
Remaining all other curve should show the values as it is without doing any summation
Currenlty matrix visual data looks like below:
Curve | Expos | TL | HD |
NG_AE | 5 | 5 | 5 |
NG_HSC | -10 | 5 | 5 |
NG_DTI | -20 | 4 | 24.73 |
NG_GYM | -20 | 1 | 0 |
LNG_JK | 5 | 1 | 5 |
AD OFF 216 | 5 | 3 | 5 |
BR_Nor | -250.72 | 2 | 5 |
Expected output:
Curve | Expos | TL | HD |
NG_AE | 5 | 5 | 5 |
NG_HSC | -10 | 5 | 5 |
NG_DTI | -20 | 4 | 24.73 |
NG_GYM | -45 | 1 | 0 |
LNG_JK | 5 | 1 | 5 |
AD OFF 216 | 5 | 3 | 5 |
BR_Nor | -250.72 | 2 | 5 |
Thanks,
SBC
No, I need to see the RAW data, not the matrix data.
Is it possible that NG-GYM is a GROUPING of NG-AE, NG-HSC, NG-DTI, and NG-GYM ? If so, create a new GROUPING on this field (in the Fields area) and pick these four 'members' to make up a Group named "NG-GYM" .
Now add this Group to the Rows portion of the Matrix and you will have a hierarchy of sorts where you can drill down NG-GYM to its componenet rows.
Proud to be a Super User! | |
Not know what the source data in TA Expos table looks like makes it hard. Can you share sample contents?
Proud to be a Super User! | |
Hi @ToddChitt ,
Input like below:
Curve | Expos | TL | HD |
NG_AE | 5 | 5 | 5 |
NG_HSC | -10 | 5 | 5 |
NG_DTI | -20 | 4 | 24.73 |
NG_GYM | -20 | 1 | 0 |
LNG_JK | 5 | 1 | 5 |
AD OFF 216 | 5 | 3 | 5 |
BR_Nor | -250.72 | 2 | 5 |
Expected output:
Curve | Expos | TL | HD |
NG_AE | 5 | 5 | 5 |
NG_HSC | -10 | 5 | 5 |
NG_DTI | -20 | 4 | 24.73 |
NG_GYM | -45 | 1 | 0 |
LNG_JK | 5 | 1 | 5 |
AD OFF 216 | 5 | 3 | 5 |
BR_Nor | -250.72 | 2 | 5 |
Expos column in the matrix was created based on below dax measure
Expos = CALCULATE(SUM('TA Expos'[expo]),USERELATIONSHIP('Calendar'[Date],'TA Expos'[Trading_Period_date]))