Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I'm stuck and cannot find the right way to solve my problem with the solutions in this forum. So forgive me if I ask the question that is already asked 100000 times...
The Case:
I have two collums : sales and fixed fee.
I created measures on those collums :
€ Opbrengst kaartverkoop = SUM( DEAL[Opbrengst tickets (TM3)] )
and:
And finaly I made this:
Solved! Go to Solution.
@Anonymous
To get the correct total, you need to use the integrator function SUMX, Replace TABLE[COLUMN] with the current table and column on against which you use these measures in the table visual.
Grondslag Partagering =
SUMX(
VALUES('TABLE'[COLUMN]),
VAR DealWel = [€ Opbrengst kaartverkoop] > [€ Garantiebedrag] RETURN
IF( DealWel, [partagering] )
)
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Anonymous
To get the correct total, you need to use the integrator function SUMX, Replace TABLE[COLUMN] with the current table and column on against which you use these measures in the table visual.
Grondslag Partagering =
SUMX(
VALUES('TABLE'[COLUMN]),
VAR DealWel = [€ Opbrengst kaartverkoop] > [€ Garantiebedrag] RETURN
IF( DealWel, [partagering] )
)
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Wow! This works! Thanks so much!!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |