Forum Discussion
Noppadon
5 years agoFrequent Visitor
How to Create Measure for Count by Condition
How to Create Measure for Count No. of Broken and No. of not Broken by Item Size Quantity Condition. In Case Case No. of Broken No. of not Broken All Size Quantity in Item as 0 0 0 Some...
- Anonymous5 years ago
HI Noppadon,
Currently, Dax formulas not able to respond with common language condition strings.
I think you need to wire measure formulas with switch function and trace current case, then you can write multiple expressions for different case calculate.Measure = VAR currCase = SELECTEDVALUE ( Table[Case] ) RETURN SWITCH ( currCase, "All Size Quantity in Item as 0", 'expression 1', "Some Size Quantity in Item less than or equal 0", 'expression 2', "All Size Quantity in Item Quantity > 0", 'expression 3', 'default process' )Write Conditional Statement Using SWITCH in DAX and Power BI
Regards,
Xiaoxin Sheng
amitchandak
5 years agoSuper User
Noppadon ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.