How to Create Measure for Count by Condition

[Noppadon]

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.

[Noppadon]

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

[Anonymous · Accepted solution]

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]

@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.