Forum Discussion

pasqualino's avatar
pasqualino
Frequent Visitor
1 year ago
Solved

table visual with multiple values

Hello, I finally achieved a decent merge of source files into one table, which looks similar to the following table. Each row represent 1 server. I need to produce a table showing something like the ...
Tips and Tricks
  • m4ni's avatar
    m4ni
    1 year ago

    Hi,

    OK please try the following.

     

    1. Create a date table and join to the data table for filtering.

    2. Add a month column to the date table using the FORMAT function.  Add month as slicer.

    3. Create 1st measure : (For ORACLE ONLY)

    Count Per Day =
    Var Result = CALCULATE(COUNTX(SUMMARIZE(Sheet1, Sheet1[Date], Sheet1[OS]), 1),FILTER(Sheet1, Sheet1[Role] = "oracle"))
    RETURN Result

    4. Create 2nd measure:

    MAX Value = MAXX('date', [Count Per Day])

     

    So using March and Oracle in your example gives me 2 because there are 2 dates with "Oracle" and thats the highest number.  See screenshot.

     

    Hope this helps.  Let me know either way.

m4ni's avatar
m4ni
Resolver I
1 year ago

Hi,

OK please try the following.

 

1. Create a date table and join to the data table for filtering.

2. Add a month column to the date table using the FORMAT function.  Add month as slicer.

3. Create 1st measure : (For ORACLE ONLY)

Count Per Day =
Var Result = CALCULATE(COUNTX(SUMMARIZE(Sheet1, Sheet1[Date], Sheet1[OS]), 1),FILTER(Sheet1, Sheet1[Role] = "oracle"))
RETURN Result

4. Create 2nd measure:

MAX Value = MAXX('date', [Count Per Day])

 

So using March and Oracle in your example gives me 2 because there are 2 dates with "Oracle" and thats the highest number.  See screenshot.

 

Hope this helps.  Let me know either way.

pasqualino's avatar
pasqualino
Frequent Visitor
1 year ago

Thanks a lot m4ni I succeeded in creating date table, I am now struggling with the Daily count as it is returning the same value if I filter for Oracle, Sql or any other value I have in my tables 😕