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