Forum Discussion

MigWare's avatar
MigWare
Helper I
6 years ago
Solved

Filtering measure with different behaviours

Hi,   I´m trying to get the number of days that someone worked in the field and I´m using the below measure to do that. It´s working when in a matrix with the worked_date field in the Rows and the ...
Need Help
  • nandic's avatar
    nandic
    6 years ago

    MigWare ,
    Card visual must display same value as total value on crosstab if it is the same measure. It is the same number, just different visualization.
    Try to remove .day part here: Table[worked_date].[Day])
    I tried to replicate data and put some dummy data, if i add .Day i get 366 both in crosstab and card. If i remove that part i get correct data both in crosstab and card.

    Without .Day:


    With .Day:


nandic's avatar
nandic
Resident Rockstar
6 years ago

MigWare ,
Card visual must display same value as total value on crosstab if it is the same measure. It is the same number, just different visualization.
Try to remove .day part here: Table[worked_date].[Day])
I tried to replicate data and put some dummy data, if i add .Day i get 366 both in crosstab and card. If i remove that part i get correct data both in crosstab and card.

Without .Day:


With .Day: