Forum Discussion

Philipp_ISARTAX's avatar
Philipp_ISARTAX
Frequent Visitor
2 years ago
Solved

Sum depending on Letters in Column

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 D...
Need Help
  • Philipp_ISARTAX's avatar
    Philipp_ISARTAX
    2 years ago

    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

Ahmedx's avatar
Ahmedx
Super User
2 years ago

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

Philipp_ISARTAX's avatar
Philipp_ISARTAX
Frequent Visitor
2 years ago

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's avatar
    Ahmedx
    Super User
    2 years ago

    after the filter must be approved ALL

    • Ahmedx's avatar
      Ahmedx
      Super User
      2 years ago

    • Ahmedx's avatar
      Ahmedx
      Super User
      2 years ago

      Share sample pbix file to help you.

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

      • Philipp_ISARTAX's avatar
        Philipp_ISARTAX
        Frequent Visitor
        2 years ago

        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