Forum Discussion
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 Size Quantity in Item less than or equal 0 | 1 | 0 |
| All Size Quantity in Item Quantity > 0 | 0 | 1 |
Example Result as attach Picture.
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
3 Replies
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.I want to create 2 Measure for Count No. of Item. by Summary Quantity Condition. I Draft Example Output in pbix file as attach Link.
https://drive.google.com/file/d/1pl-SdqgVo0HwgcNJfESfP-CjU4t9dpg9/view?usp=sharing
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
