Forum Discussion
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
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
3 Replies
- parry2k
Super User
carloscabreraq you have to use format function get respective format for each row.
- v-lili6-msft
Community Support
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
- carloscabreraq
Helper I
v-lili6-msft parry2k Thanks!