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.
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.
Solved! Go to 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
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
@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.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |