displaying multiple measures in one table

[Anonymous]

Hi,

I would like to create a new table which displays four seperate measures. The result should look like:

Column 1                     Column2
Name of measure 1     Result measure 1

Name of measure 2     Result measure 2
Name of measure 3     Result measure 3
Name of measure 4     Result measure 4

The result of the measures is always one numerical number.

How can I create a new table which displays multiple measures? 

Thank you for your help on this.


PS hereby an example of one of the measures:
Measure 1 = 
VAR calc1 = CALCULATE(DISTINCTCOUNT(FACT_C[CID]), FACT_C[OTC] = 1)
VAR calc2 = DISTINCTCOUNT(FACT_C[CID])

RETURN
FORMAT(DIVIDE(calc1, calc2,0),"0%")

[v-rzhou-msft · Accepted solution]

Hi @Anonymous 

If you create a table to show your measures, the result of measure will be a determind aggregation value, it won't be dynamic. 

My Sample

Here I create 4 measures to calculate sum, min, max and average of Sales.

Then create a new table to show results calculated by measure.

Table 2 = 
VAR _MEASURENAME = { "Measure1", "Measure2", "Measure3", "Measure4" }
VAR _ADDCOLUMN =
    ADDCOLUMNS (
        _MEASURENAME,
        "Measure",
            SWITCH (
                [Value],
                "Measure1", [Measure1],
                "Measure2", [Measure2],
                "Measure3", [Measure3],
                "Measure4", [Measure4]
            )
    )
RETURN
    _ADDCOLUMN

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , on Matrix, Use option Show on rows.

and No row / No column

Only measures in values 

[Anonymous]

Some more detail / more clarification:

I need to create a new table for these measures because I am going to use them in the "charticulator" chart in PowerBI. For charticulator to work, I need to have all the data in one table together.

Which measure do I need to write to create a table out of multiple measures?