Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Olá, tenho a Matriz abaixo com as seguintes métricas
Solved! Go to Solution.
Hi @Anonymous
Thanks for reaching out to us.
The first 2 measures are working fine, right? So for TesteCad4, you can try the measure below. (As there is no sample data to test, not sure if it works, just try it.)
create the measure, and put it into table visual,
testTesteCad4 =
IF (
HASONEFILTER ( LotDailyCadence[LotNumber] ),
[TesteCad4],
SUMX (
FILTER (
LotDailyCadence,
LotDailyCadence[Date] >= DataInicial
&& LotDailyCadence[Date] <= DataFinal
&& LotDailyCadence[LotNumber] IN _Lote
),
[TesteCad4]
)
)
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
this worked, thanks a lot for the help
Hi @Anonymous
Thanks for reaching out to us.
The first 2 measures are working fine, right? So for TesteCad4, you can try the measure below. (As there is no sample data to test, not sure if it works, just try it.)
create the measure, and put it into table visual,
testTesteCad4 =
IF (
HASONEFILTER ( LotDailyCadence[LotNumber] ),
[TesteCad4],
SUMX (
FILTER (
LotDailyCadence,
LotDailyCadence[Date] >= DataInicial
&& LotDailyCadence[Date] <= DataFinal
&& LotDailyCadence[LotNumber] IN _Lote
),
[TesteCad4]
)
)
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
120 | |
69 | |
68 | |
57 | |
50 |
User | Count |
---|---|
166 | |
82 | |
68 | |
65 | |
53 |