Forum Discussion
Convert a card into a measure
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?
I managed to create the measure independently from the visual, by using the example shown here
Something likeCALCULATE(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")
)
Microsoft EmployeeHi bmannato
Probably. Can you please describe the number you are using on your card. Eg, it is the SUM of a particular field.
The number is the sum of all sales of my ecommerce, filtered (at visual level) by a column that says wether it's the current month, and by the column that says the status of each purchase (in this case, I'm filtering only confirmed payments, preparing for shipment, sent, and delivered orders, excluding cancelled, expired, and frauds). I don't know how to apply so many filters at once using DAX expressions, that's why I wondered if it was possible to create a measure base on the value of the card.
Thanks in advance
- Phil_Seamark
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?
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.
I managed to create the measure independently from the visual, by using the example shown here
Something likeCALCULATE(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")
)