Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello
I want to use a DAX measure (not a calculated column) as a fourth column (outlined in red, below) within a table visualisation.
However, my DAX only returns the single row:
DAX =
VAR varStatusGroup = "Final"
VAR varStatus = "Disposed"
RETURN
CALCULATE (
MIN('Status'[Status])
,KEEPFILTERS('Status'[Status group] = varStatusGroup)
,KEEPFILTERS('Status'[Status] = varStatus)
)
What am I doing wrong?
I want:
Data model:
Hi @noneother
Based on your post and dax you shared, you want to show "Disposed" in the fourth column, so if I got it correctly, try this:
DAX =
"Disposed"
Otherwise, can you please add more details?
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
@noneother does this work?
CALCULATE (
MIN('Status'[Status])
,'Status'[Status group] = "Final"
,'Status'[Status] = "Disposed"
)
That works but I introduces redundant rows, creating way more than the original 5 rows for Type ID: AEG3ML
@noneother is it kindly possible to provide a sample pbix please?
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
11 | |
11 | |
10 | |
6 |