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
Go to Solution.
You may try a similar way as shown here.
View solution in original post
Are your two calculations both measures? or is one/both a calculated column?
What is the missing column used to create rows?
Proud to be a Datanaut!
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.
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.