Forum Discussion
Anonymous
7 years agoNot applicable
Differents results in 2 differents visuals
Hi,
I create a calculated measure and the result is different in a table visual and a card visual. Here is the measure:
Pmp gross_date =
var BoisNet = CALCULATE(sumx(paquets;paquets[PMPR]);FILTER('end';'end'[DateCommande] = 1))
var BoisGross = CALCULATE(ROUNDDOWN(sumx(paquets;paquets[PMPR]) * 1,08;0);FILTER('end';'end'[DateCommande] = 1))
Return
if(or(SELECTEDVALUE(paquets[RefEtatBois]) = 6;SELECTEDVALUE(etatbois[RefEtatBois]) = 5);BoisNet;BoisGross)The filter is because I choose a date to create the report. Here is the result:
The calculated measure in the column of the table visual and in the card visual (surrounded with red circle) is the same.
I don't understand why.
Thanks
2 Replies
- Greg_Deckler
Community Champion
Tough to say exactly, are you 100% sure that you don't have some filter on that table visual? What else is in that table?
- AnonymousNot applicable
I share the file. If i remove the column «Etat» of the table visual, I get the same result then the card visual.
Thanks