count of

2 Topics

count with condition
Hi All, this is my data sample: Account id attackid attack date module assessName status 1 01 1/1/22 aa xx failed 1 02 2/1/22 aa yy failed 1 03 2/1/22 cc xx failed 1 04 3/1/22 aa xx completed 2 05 1/1/22 tt ss failed 2 06 2/1/22 tt ss failed 2 07 2/1/22 aa hhh failed 2 08 10/1/22 aa hhh failed 3 09 1/1/22 rr pp failed 3 10 2/1/22 aa mm failed 3 11 8/1/22 rr pp failed i'm trying to disply a table that will give me all account that runs 2 failed attakcs in row the attack must to be in a row and must to have same assessName and same module name for example account 2 had 2 failed attacks in a row with the same module = tt and the same assessName = ss acount can answer this conditions correctly more then 1 time, for example account 2 add another 2 failed attacks in a row with the same module = aa and the same assessName = hhh i want to disply on the report a table with all the attacks that answer these conditions id Last attack date module assessName 2 2/1/22 tt ss 2 10/1/22 aa hhh and then count the number of attacks that answer these conditions (count shold be 2 base on the sample data) can it be done only with maesure and not with calculated column/table ? pls help 🙂
Solved
ReutAtias12
3 years ago Place DAX Commands and Tips
1.7KViews
0likes
8Comments
Number value is adding to Chart as 'Count of'
I have a chart that looks like the below. When I convert this to a line and column, it automatically convert the 'PM Count' column to be 'Count of PM Count' and therefore displays the values incorrectly. Below you can see that field is clearly a numeric value and is formatted as such.
CharlotteOW
4 years ago Place Desktop
1.1KViews
0likes
4Comments