Forum Discussion

Jacks060650's avatar
Jacks060650
Frequent Visitor
2 years ago

Helping counting entries

Hello,    I currently have a table with dates ( please see attached), I would like to count how many entries per date to put it onto a card visual so I can see how many lates for example we had on ...
Jihwan_Kim's avatar
Jihwan_Kim
Super User
2 years ago

Hi, I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

Please check the below pictures and the attached pbix file.

 

 

Expected result measure: = 
VAR _t =
    ADDCOLUMNS (
        Data,
        "@countrows", COUNTROWS ( FILTER ( Data, Data[Created] = EARLIER ( Data[Created] ) ) )
    )
RETURN
    CONCATENATEX (
        SUMMARIZE ( _t, Data[Created], [@countrows] ),
        Data[Created] & "  - " & [@countrows] & " entry(entries) made",
        UNICHAR ( 10 )
    )

 

Jacks060650's avatar
Jacks060650
Frequent Visitor
2 years ago

It looks a good way however the card I would like it just showing the number for the day.  (Please ifnd attached image)

 

For example I have taken 23 sick calls today and if i filter it by date on the image it will let me see that 23 people called in sick, if that makes sence? 

 

 

 

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    2 years ago

    Hi, Thank you for your message.
    I think the solution is related how you model your data, because I think, it shows count of rows in the fact table.
    Please share your sample pbix file's link here, and then I can try to look into it to come up with a solution.

    Thanks.