I have a measure I use in an clustered column chart, the syntax is below :
CalculateTickets = COUNT(FactTable[TicketSK])
In the chart I added the Status as an axis and I want to add a card for the total of each status
What is the best approach between :
- Use the same measure and apply a filter on the card based on the Status dimension
-Create a new measure like below :
CalculateTickets Test=
CALCULATE ([CalculateTickets], DimStatus[StatusLabel] ="On Hold")
What is the best approach and why ?
Solved! Go to Solution.
@AmiraBedh , Having 1 or 2-level measure looping is fine ( measure used inside measure)
But you need sure about the difference between
CalculateTickets Test=
CALCULATE ([CalculateTickets], DimStatus[StatusLabel] ="On Hold")
and
CalculateTickets Test=
CALCULATE ([CalculateTickets], Filter(DimStatus, DimStatus[StatusLabel] ="On Hold"))
http://dataap.org/blog/2019/04/22/difference-between-calculate-with-and-without-filter-expression/
@AmiraBedh , Having 1 or 2-level measure looping is fine ( measure used inside measure)
But you need sure about the difference between
CalculateTickets Test=
CALCULATE ([CalculateTickets], DimStatus[StatusLabel] ="On Hold")
and
CalculateTickets Test=
CALCULATE ([CalculateTickets], Filter(DimStatus, DimStatus[StatusLabel] ="On Hold"))
http://dataap.org/blog/2019/04/22/difference-between-calculate-with-and-without-filter-expression/
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
User | Count |
---|---|
216 | |
53 | |
43 | |
42 | |
42 |
User | Count |
---|---|
269 | |
210 | |
73 | |
72 | |
64 |