Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Count values depending on a condition

Hi all,   my next question :)   I've got a table with dates and available status (1 and 0.5).   What I want to achieve is when I plot the values in an area chart I see that on the 4the of janua...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi MFelix,

     

    Maybe you can try to use summarize function to create a summary table:

    Table = SUMMARIZE(Table1,[Date],"Total Day",SUM(Table1[Avaliable Days]))

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI Anonymous, 

 

If you use numeric value to record available days, I think you can use sum function to get the total available days. 

 

Sample:

Total available days =
CALCULATE (
    SUM ( table[avaliable days] ),
    FILTER ( ALL ( table ), table[First login] = MAX ( table[First login] ) )
)

 

In addition, you can also add filters to calculate with available day as the parameter of calculation. ( countrows *1 + countrows * 0.5)

 

Regards,

Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi I can't get it working.

 

The result that i want is that I can plot this to an area chart where also some kpi's are shown.

 

Result:

First login                 Available

4/01/2017                  4,5

5/01/2017                  8

 

Hope that you can give me some more advice thanks!

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi MFelix,

     

    Maybe you can try to use summarize function to create a summary table:

    Table = SUMMARIZE(Table1,[Date],"Total Day",SUM(Table1[Avaliable Days]))

     

    Regards,

    Xiaoxin Sheng