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.
Hi everyone i'm new on power bi and i have a problem with sumx All as follow:
I have a mesure calculated like this to count the types of last year:
prop test = CALCULATE(COUNT(f_table1[Type]);PREVIOUSYEAR(f_table1[Date]); f_table1[Type] = "xxxx")
In a seconde mesure i'm trying to get the total of prop test using SUMX
sumx column = SUMX(ALL(f_table1);f_table1[prop test])
I have blank results i dont know why ? could you pleaase help me
Solved! Go to Solution.
You may try a similar way as shown here.
Hi @ZakEx
Are your two calculations both measures? or is one/both a calculated column?
What is the missing column used to create rows?
Both of calculations are mesures based on a date filter, what i'm trying to do is to get the total of the first mesure "prop test", i don't have a calculated column.
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 |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |