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:
Solved! Go to Solution.
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!
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.