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

I feel you need to re-evaluate what exactly you are trying to measure.  What is it you are trying to average?  What is it you are trying to find the MAX of?

Your description tells me it is counts of enteries per day but summarized by month.  Worth just clarifying..

  • pasqualino's avatar
    pasqualino
    Frequent Visitor
    1 year ago

    hello m4ni my apologies for the unclear explanation. Yes, I want to count all the appearances of Oracle, for instance and return: how many oracle there were on average on the chosen month? What was the highest volume (daily based) on a selected month?