Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello All,
Purpose:
I required DAX formula for 'Count greater than 100 of Order Since column ' . Order since is Direct Query Meaure column
e.g. ( Order Since = DATEDIFF(SELECTEDVALUE('Production Ready'[orderdate]),TODAY(),DAY) )
Explanination:
I want DAX in Direct Query to calculate for how many times the value is greater than 100 in order since column. i.e. 20 times,
to put value (20) into Card Tile. so that i can create alert in power bi service
Suggestions:
If you have any other solution, Please suggest.
Let me know, if require any other clarification
Thanks,
Solved! Go to Solution.
Hi FreemanZ,
above shared DAX is working but it shows wrong count no.
If I used 'ALL' inside FILTER then it shows 28k (which is completely wrong. and does not change with Date slicer) but If I used 'ALLSELECTED' then it shows nearer to value but not correct.
I can see only 6 values which is above 100, but it shows 19.
and the value should change according to Date changes.
Let me know anything required,
Thanks.
Is [measure 2] really a measure? try to change it to column name - Order Since
Yes, It is a measure. I Rename it as 'Order Since'
Measure 2 = Order Since = DATEDIFF(SELECTEDVALUE('Production Ready'[orderdate]),TODAY(),DAY)
the screenshot is basically a record table, suggest to add a new column in your table, with such code:
Order Since = TODAY() - TableName[Order Dt.],
then use this code for the measure:
100PlusCount :=
Yes it is record table. it is connected to postgresql database. and it came as Direct query
as you mention, not able to add column due to error
Order Since = Today() - 'Poduction Ready'[orderdate] i.e. 'Production Ready' is table name.
and so,
100PlusCount :=
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
9 | |
8 | |
8 | |
8 |
User | Count |
---|---|
13 | |
12 | |
11 | |
10 | |
8 |