Forum Discussion
Anonymous
3 years agoNot applicable
Measure not displayed correctly
Hello everyone!
I applied the following measure to my matrix visual:
Ngroup1 = SUMX (
GROUPBY ( 'Sheet1', 'Sheet1'[Fiscal year], 'Sheet1'[Obligation type] ),
[Group 1]
)Ngroup2 = SUMX (
GROUPBY ( 'Sheet1', 'Sheet1'[Fiscal year], 'Sheet1'[Obligation type] ),
[Group 2]
)Ngroup3 = SUMX (
GROUPBY ( 'Sheet1', 'Sheet1'[Fiscal year], 'Sheet1'[Obligation type] ),
[Group 3]
)
When I checked my visuals, I noted there are rows in which the measure seems to not work correctly:
Kindly advise on this matter - why it happens and any way to fix it.
Best regards,
Bona
3 Replies
- AnonymousNot applicable
Hi Anonymous ,
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
- AnonymousNot applicable
- AnonymousNot applicable
HI Anonymous,
Can you please share more about the 'group' that you used in the measure expression?
Regards,
Xiaoxin Sheng