Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
51 | |
34 | |
19 | |
15 | |
14 |
User | Count |
---|---|
94 | |
80 | |
37 | |
22 | |
18 |