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,
I've read a thread with the similar title, but my case is somewhat different. I have a measure:
New clients = IF([Sales in Previous Period]=0 && [Sales in Last Selected Month]>0 ,1 ,0)
How do I sum the New clients measure? I failed to do it with COUNT, as it requires a column reference as an argument.
Solved! Go to Solution.
Hey,
w/o having more details about you model I guess you could use an iterator like this:
CALCULATE (SUMX( VALUES('yourtable'[clientid]) ,IF([Sales in Previous Period]=0 && [Sales in Last Selected Month]>0 ,1 ,BLANK()) )
I just replaced the zero from the FALSE part of the IF statement with BLANK(), avoiding to add meaningless values (from my point of view) to the RAM.
Hope this gets you started
Regards
Tom
Hey,
w/o having more details about you model I guess you could use an iterator like this:
CALCULATE (SUMX( VALUES('yourtable'[clientid]) ,IF([Sales in Previous Period]=0 && [Sales in Last Selected Month]>0 ,1 ,BLANK()) )
I just replaced the zero from the FALSE part of the IF statement with BLANK(), avoiding to add meaningless values (from my point of view) to the RAM.
Hope this gets you started
Regards
Tom
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 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |