hello @lbendlin
how can i use single logic ?
can you please giud me ?
my reuirenment is very simple
this measure result
Total Names Count Divided by 3 =
VAR SelectedMonths = VALUES('CustomTable'[MonthIndex])
VAR SelectedYears = VALUES('CustomTable'[Year])
VAR SelectedProperties = VALUES('CustomTable'[Property])
RETURN
DIVIDE(
COUNTROWS(
FILTER(
'Move Insq',
'Move Insq'[MonthIndex] IN SelectedMonths &&
'Move Insq'[YearPart] IN SelectedYears &&
'Move Insq'[Property] IN SelectedProperties
)
),
3
)
divide with this measure total
Total Move insq percent =
VAR LeasingAgentsWithCustomData =
FILTER(
'Move Insq',
'Move Insq'[MonthIndex] IN VALUES('CustomTable'[MonthIndex]) &&
'Move Insq'[YearPart] IN VALUES('CustomTable'[Year]) &&
'Move Insq'[Property] IN VALUES('CustomTable'[Property]) &&
'Move Insq'[First Name] <> BLANK()
)
RETURN
DIVIDE(
COUNTROWS(LeasingAgentsWithCustomData),
3
)
so concept is i have column called first name
there is multiple names and also has same names now i created this measure which will count total and then divide 3
Total Move insq percent =
VAR LeasingAgentsWithCustomData =
FILTER(
'Move Insq',
'Move Insq'[MonthIndex] IN VALUES('CustomTable'[MonthIndex]) &&
'Move Insq'[YearPart] IN VALUES('CustomTable'[Year]) &&
'Move Insq'[Property] IN VALUES('CustomTable'[Property]) &&
'Move Insq'[First Name] <> BLANK()
)
RETURN
DIVIDE(
COUNTROWS(LeasingAgentsWithCustomData),
3
)
and also with that i created another measure which will count names how many times name appear and then divide 3
now third value i want which will show percentage so i want that count names measure will divide with total counts measure value example total count i get after divide with 3 is 32 and my counts per name total 4,6,7,8,9 as per data names. should be divide with with total means 32
4/32 , 6/32, 7/32 ....... now whatever value comes with this calculation that is my percentage value.
| MonthIndex | Year | property | First name |
| 5 | 2023 | London | Lency luis |
| 3 | 2023 | Paris | David becahar |
| 5 | 2023 | Tokyo | lency luis |
| 5 | 2024 | Maldivs | lucky fire |
| 4 | 2024 | America | David jhones |
| 4 | 2024 | Egypt | David jhones |
