Table with measures in rows and columns

[Anonymous]

Hello,

is it possible to place measures in table/matrix as below in Power BI? Basically I know how to create all the measures, but I don't know how to allocate them in presented way. Many Thanks, Kamil 

[MargaritaG]

to format calculation groups select in Property Format String Expression

[amitchandak]

@Anonymous , You have create a custom table or calculation groups

example

union(
summarize('Table',"Measure","Min","Test1",min('Table'[Test1]),"Test2",min('Table'[Test2]),"Test3",min('Table'[Test3]))
summarize('Table',"Measure","Max","Test1",max('Table'[Test1]),"Test2",max('Table'[Test2]),"Test3",max('Table'[Test3]))
)
"QTD" , "YTD" , "MTD"

union(
summarize('Table',"Measure","sales","This period",[SALES YTD],"Last period",[SALES LYTD],"POP",[SALES YOY])
summarize('Table',"Measure","unit","This period",[unit YTD],"Last period",[unit LYTD],"POP",[unit YOY])
)

But new table will not take filters so you need to add them as a group by in the new table  and join them with dimensions again

tabular - Calculation groups
https://docs.microsoft.com/en-us/analysis-services/tabular-models/calculation-groups?view=asallproducts-allversions#limitations

[Anonymous]

Hi @amitchandak ,

Thank you for support, you are very helpful as always 🙂 I used calculation group in order to create desired table. I approached next challange - I wanted to apply conditional formatting for 2 out of 6 calculated items. Is there any possibility for this? Thanks, Kamil