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

    )