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.
Solved! Go to Solution.
Hey @NISH72 ,
this does not clarify the potential outcome of [measure 1], provide the DAX code for [mesure 1].
I still assume that using SUMX() will be part of the solution.
Regards,
Tom
SUM works with columns. The question is, sum this measure over what? This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149
Hey @NISH72 ,
basically it's not clear what the measure [measure 1] will return ...
You might look into one of the table iterator functions like SUMX and create a measure like so:
SUMX(
'table' //the table to iterate
, IF([measure 1] ... //the condition
, 1 //true
, BLANK() //false
)
)
If this does not help, please create a pbix that contains sample data, upload the file to onedrive or dropbox and share the link.
Don't forget to describe the expected outcome based on your sample data.
Regards,
Tom
Hey @NISH72 ,
this does not clarify the potential outcome of [measure 1], provide the DAX code for [mesure 1].
I still assume that using SUMX() will be part of the solution.
Regards,
Tom
Hey @NISH72 ,
I doubt that, as there is a syntax issue IF[measure], 1, 0) should look like IF([measure], 1, 0)
Nevertheless, try this for measure 2:
SUMX(
'table' //the table to iterate
, IF([measure] ... //the condition
, 1 //true
, BLANK() //false
)
)
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 |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |