Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
i have below rows need last column (row_count) as result that is
if system is a or b i need to do row count based on type if system is c i need to add rowcnt
can any one help me in this
system type rowid rowcnt row_count
a x 11 22
a y 22 32
b x 13 22
b y 32 32
c x 111 20 22
c y 212 10 32
c y 212 20 32
Solved! Go to Solution.
Hi @Anonymous ,
Check the formula.
Column = IF('Table'[system]="a"||'Table'[system]="b",CALCULATE(MAX('Table'[rowid]),FILTER(ALLEXCEPT('Table','Table'[type]),'Table'[system]="a"||'Table'[system]="b")),IF('Table'[system]="c",CALCULATE(MAX('Table'[rowid]),ALLEXCEPT('Table','Table'[type])))+'Table'[rowcnt])
Result would be shown as below.
Best Regards,
Jay
Hi @Anonymous ,
Check the formula.
Column = IF('Table'[system]="a"||'Table'[system]="b",CALCULATE(MAX('Table'[rowid]),FILTER(ALLEXCEPT('Table','Table'[type]),'Table'[system]="a"||'Table'[system]="b")),IF('Table'[system]="c",CALCULATE(MAX('Table'[rowid]),ALLEXCEPT('Table','Table'[type])))+'Table'[rowcnt])
Result would be shown as below.
Best Regards,
Jay
Either something like the above or add some columns on or detail records
typeXcount: IF (system = a or system = b) and type= x then 1 else 0
typeYcount: IF (system = a or system = b) and type = y then 1 else 0
typeCcount: IF (system = c) then 1 else 0)
In your visual you can then just sum the columns
@Anonymous , logic is not clear with the data you have shown.
It seem like this measure
calculate(counrows(Table), allexcept(Table, Table[Type]))
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |