Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello All,
I have data , where i have Due days. i want to create a measure that only show me days which is >=1 .
@sandee
If you need a measure to count the record then:
Logic =
COUNTROWS(
FILTER(
'Table Aging,
Table Aging'[Days Due] >1
)
)
otherwise click on New Table in the modeling tab and paste
Logic Table =
FILTER(
'Table Aging,
Table Aging'[Days Due] >1
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thank u Fowmy, it worked , but i got the complete table, what if i want one column only "Due Days >=1. should i use Value and Filter?
User | Count |
---|---|
69 | |
43 | |
21 | |
21 | |
14 |
User | Count |
---|---|
124 | |
42 | |
39 | |
28 | |
25 |