Forum Discussion

LuisLOCapelari's avatar
LuisLOCapelari
Icon for Helper I rankHelper I
3 years ago

Summarize filtering by date

Hey guys. I'm Brazilian and I need to do a dax to calculate the amount of ID_GERADOC for each ID_LOGIN in the FATO_GERADOC table, in a given period. This period will be selected in a slicer from the ...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi  LuisLOCapelari ,

 

You can try using the following dax:

Measure =
var _select=SELECTEDVALUE('DIM_DATA'[Data])
return
COUNTX(
    FILTER(ALL(FATO_GERADOC),
    'FATO_GERADOC'[ID_LOGIN]=MAX('FATO_GERADOC'[ID_LOGIN])&&'FATO_GERADOC'[DATA_REGISTRO]<=_select),'FATO_GERADOC'[ID_GERADOC])

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

LuisLOCapelari's avatar
LuisLOCapelari
Icon for Helper I rankHelper I
3 years ago

Hello Anonymous . This doesn't work. Because there are several date filters, there is no single value to get from SELECTEDVALUES.
The idea is to be able to filter according to year, quarter and month. And dynamically, for the selected period, generate a table calculating the number of lists generated by each teacher. Then, discover the unique values for the number of lists, and for each number of lists, find out how many teachers fit into this group.
I will attach images illustrating it.