Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

displaying multiple measures in one table

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%")

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , on Matrix, Use option Show on rows.

    and No row / No column

     

    Only measures in values 

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.