Sum depending on Letters in Column

[Philipp_ISARTAX]

Hello all,

I'm a newbie in working with Power BI.

Actualy I have a data model with a tble which has in One Row several letters and in another row values.

Now I try to create a Measure with DAX-Formula which calculates the sum of the values only for the lines, where the Letter "B" is mentioned in the column of the letters.

I tried my best with SUMX or CALCULATE but it doesn't work and I don't understand why.

My Measure was:

 = CALCULATE(Sum('Table'[column_values]);'Table'[column_letters]="B")

Many thanks for your support!

[Philipp_ISARTAX · Accepted solution]

Hello @Ahmedx  and @Uzi2019 ,

Thanks for your support. I found the solution.

The data in the table is not "V", it is " V" with a leading Space! This took hours to find out for me 😂
But I'm happy that it is now working.

Thanks for your support,

Kind regards,

Philipp

[Uzi2019]

Hi @Philipp_ISARTAX 
Can you share sample data and expected output??

[Ahmedx]

To understand why your measure does not work, share some data

[Philipp_ISARTAX]

Hello @Ahmedx ,

hello @Uzi2019 ,

Please find as follows a screenshot from the table "Abgerechnete Gebühren" from Power Query with the relevant columns:

Here is the Measure and the used DAX-Formula:

I would have expected the summarized total of the columns "Gebührenbetrag mit Mult..." over the lines where the letter "V" is in column "Abrechnungsart Gebühren".

As you can see in the card, the result is empty! 

[Ahmedx]

after the filter must be approved ALL

[Ahmedx]

Share sample pbix file to help you.

or try this
CALCULATE(SUM(....), FILTER(ALL(.....

[Philipp_ISARTAX]

Hello @Ahmedx ,

I don't know, if this works. Please find as follows the Link to the Sample-pbix-File:

Problem Sample.pbix

Thanks, Kind regards

[Philipp_ISARTAX]

Hello @Ahmedx ,

it doesn't work:

[Ahmedx]