Forum Discussion
Post ProdigySum values in column by condition in Power Bi
Resident Rockstarhm Analitika
Can you try:
kiekis_test1 =
CALCULATE(
sum(op_detales[qty_in]),
LASTDATE(op_detales[Dokumento data])
)
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
Post ProdigyYeah I am getting 0
- Mikelytics
Okay, since the data is coming but the value is zero it ahst to be one fo these filters
Beacuse you measure identifies the right data but the result is zero. This means there further criteria which filter out further rows. It has to be one of those.
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread. - Analitika
I checked that not affects calculations, I think filter in measure not works well.
- Mikelytics
HI Analitika
This is really a normal measure filter Can you please try the following twpo options.
1) Take out all the filter on the visual and look for the result
2) Create a normal SUM measure and filter on the date which you got from last date
Can you please tell what happens?
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread. - Analitika
Actually I investigated interesting thing like that measure works if filter document number, it calculates well, but problem with data, when comparing. I can't get why it happens?
- Analitika
Filtering works well with other columns, with date it doesn't work. So seems problem is with date.