Forum Discussion

bmannato's avatar
bmannato
Frequent Visitor
9 years ago
Solved

Convert a card into a measure

I created a Card (hence, a Visual), by applying some filters into a column from my dataset. Is there an easy way to convert the resulting number into a measure? I'm not that familiar with DAX express...
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    Hi bmannato

     

    There is no feature to auto-create a measure from a card like that. You have created any measures at all so far?

  • bmannato's avatar
    bmannato
    9 years ago

    I managed to create the measure independently from the visual, by using the example shown here
    Something like

    CALCULATE(SUM(Orders[total]);

          FILTER(Orders;Orders[LastMonth]="LastMonth");

          FILTER(Orders;Orders[status]="pent" ||

          Orders[status]="pe" ||

          Orders[status]="le" ||

          Orders[status]="ps" ||

          Orders[status]="pp")

    )

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi bmannato

 

There is no feature to auto-create a measure from a card like that. You have created any measures at all so far?

bmannato's avatar
bmannato
Frequent Visitor
9 years ago

Yes, I've created some simple measures (e.g sum of all purchases, regardless of any filter), and some tables with single filtering, using functions like SUM, CALCULATE, and SUMMARIZE. 

  • bmannato's avatar
    bmannato
    Frequent Visitor
    9 years ago

    I managed to create the measure independently from the visual, by using the example shown here
    Something like

    CALCULATE(SUM(Orders[total]);

          FILTER(Orders;Orders[LastMonth]="LastMonth");

          FILTER(Orders;Orders[status]="pent" ||

          Orders[status]="pe" ||

          Orders[status]="le" ||

          Orders[status]="ps" ||

          Orders[status]="pp")

    )