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

after the filter must be approved ALL

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