Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, guys, I will appreciate your help sices now.
I have 2 cards, the first one is base on the following filter:
me_trps_tv_abierta = CALCULATE(SUM(fact_registry[value_total]), FILTER(fact_registry, fact_registry[id_kpi] ==9))
and the second one it is the same, just for the last month:
me_trps_tv_abierta previous month = CALCULATE(SUM(fact_registry[value_total]), FILTER(fact_registry, fact_registry[id_kpi] ==9), PARALLELPERIOD(fact_registry[date_added], -1, MONTH))
The problem is that if I do a filter per month on the dashboard, I lose the information from the last month.
How can I solve this problem?
Hi @Anonymous,
try to write your measure like this:
Measure =
CALCULATE (
CALCULATE ( SUM ( 'Table'[Val] ); FILTER ( 'Table'; 'Table'[id_kpi] == 1 ) );
PARALLELPERIOD ( DimDate[Date]; -1; MONTH )
)
Cheers,
Sturla
If this post helps, then please consider Accepting it as the solution. Kudos are nice too.
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |