The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a measure working as expected(below).
SalesCount = IF(
[QTY] <= 0,
"A",
IF(
ABS(1 - DIVIDE([Sales1], [Sales2])) < 10,
"B",
"A"
)
)
I need to count number of rows equal to "A" and
number of rows equal to "B" . For this calculations, I need to use measure.
Please help.
Thanks
Solved! Go to Solution.
Hi,
I am not sure how your datamodel, and how your expected visualization looks like, but please try the below.
Count A: =
VAR _tableA =
FILTER (
ADDCOLUMNS (
VALUES ( TableName[ColumnInTheVisualization] ),
"@salescount", [SalesCountMeasure]
),
[@salescount] = "A"
)
RETURN
COUNTROWS ( _tableA )
Count B: =
VAR _tableB =
FILTER (
ADDCOLUMNS (
VALUES ( TableName[ColumnInTheVisualization] ),
"@salescount", [SalesCountMeasure]
),
[@salescount] = "B"
)
RETURN
COUNTROWS ( _tableB )
Hi,
I am not sure how your datamodel, and how your expected visualization looks like, but please try the below.
Count A: =
VAR _tableA =
FILTER (
ADDCOLUMNS (
VALUES ( TableName[ColumnInTheVisualization] ),
"@salescount", [SalesCountMeasure]
),
[@salescount] = "A"
)
RETURN
COUNTROWS ( _tableA )
Count B: =
VAR _tableB =
FILTER (
ADDCOLUMNS (
VALUES ( TableName[ColumnInTheVisualization] ),
"@salescount", [SalesCountMeasure]
),
[@salescount] = "B"
)
RETURN
COUNTROWS ( _tableB )
User | Count |
---|---|
27 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
31 | |
15 | |
12 | |
7 | |
6 |