HOW TO TAKE THE SUM OF SPECIFIC CATEGORY IN A COLUMN

[Anonymous]

Dear all,

I would like to take the sum of turnover - TGS (LC -> Cur) -  related to specific categories in "PartType 04" column. In this case would be "OGOW" to be filteres.

Then i applied this measure, which is not working:

What's my failure? I get a blank when i do it.

Thanks in advance for your support.

[v-yiruan-msft]

Hi  @Anonymous ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards

[Anonymous]

Hello @DataInsights ,

I tried you suggestion and i still get a blank card, even having values to be filtered.

Have no clue what's going on with a super simple formula...

[v-yiruan-msft]

Hi @Anonymous ,

Please check if you apply any filter or slicer in the page? Or any special visual-level filter on the card visual? Could you please provide some mocked data with Text format (exclude sensitive data) and some screenshot of your report page setting? It is better if you can provide a simplified pbix file. Thank you.

Best Regards

[DataInsights]

@Anonymous,

If you can share your pbix (remove sensitive data), I'll take a look.

[SpartaBI]

@Anonymous PM me

[DataInsights]

@Anonymous,

Try this measure:

EUR ST OGOW TGS =
CALCULATE (
    SUM ( OB_EUR[TGS (LC->CUR)] ),
    OB_EUR[PartTyp04 - SP S (M)] = "OGOW"
)