Forum Discussion
carloscabreraq
7 years agoHelper I
Different row data Type in Matrix
Hello, how can i get different row data type in a Matrix. For example Measure MTD, row A = integer, B percentage and C = numeric with 2 decimals. Thanks for your help
- 7 years ago
HI, carloscabreraq
After my test, you could try this way as below:
Use FORMAT Function with IF/ SWITCH in your formula of measure.
For example:
Measure = VAR _A = CALCULATE ( SUM ( 'Table'[Qty] ), FILTER ( 'Table', 'Table'[Type] = "MTD" ) ) RETURN IF ( SELECTEDVALUE ( 'Table'[ID] ) = "A", FORMAT ( _A, "0" ), IF ( SELECTEDVALUE ( 'Table'[ID] ) = "B", FORMAT ( _A, "0.0%" ), IF ( SELECTEDVALUE ( 'Table'[ID] ) = "C", FORMAT ( _A, "0.00" ) ) ) )Measure 2 = VAR _A = CALCULATE ( SUM ( 'Table'[Qty] ), FILTER ( 'Table', 'Table'[Type] = "LMTD" ) ) RETURN IF ( SELECTEDVALUE ( 'Table'[ID] ) = "A", FORMAT ( _A, "0" ), IF ( SELECTEDVALUE ( 'Table'[ID] ) = "B", FORMAT ( _A, "0%" ), IF ( SELECTEDVALUE ( 'Table'[ID] ) = "C", FORMAT ( _A, "0.00" ) ) ) )By the way, for B percentage, FORMAT ( _A, "0.0%" ) and FORMAT ( _A, "0%" ) is used for decimals.
Result:
and here is the document for you refer to
https://docs.microsoft.com/en-us/dax/custom-numeric-formats-for-the-format-function
Best Regards,
Lin
parry2k
7 years agoSuper User
carloscabreraq you have to use format function get respective format for each row.