Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello,
In a visualization, I want showing in the y axis for each data series item
I have 2 DAX expressions
AgeGT14Days = COUNTROWS(FILTER(ALL('AssetManagement Open_N2'),'AssetManagement Open_N2'[Created on] < today()-14))
AgeEqORLt14Days = COUNTROWS(FILTER(ALL('AssetManagement Open_N2'),'AssetManagement Open_N2'[Created on] >= today()-14))
however for
I'm getting the sum of all the data series items' counts, not for the specific data series item's count.
The count for the Count Of Notification within the data series item is working correct through.
Any suggestions on a fix?
Solved! Go to Solution.
Hi @Anonymous ,
Is that you want to calculate how many days are there depend on Min work center?
the results of two centers are same due to the function ALL(), it remove all the filter, so the result is the same. my solution is add more detail for the filter.
Try the following expression:
AgeGT14Days =
COUNTROWS(
FILTER(
ALL( 'AssetManagement Open_N2' ),
'AssetManagement Open_N2'[Created on]
< TODAY() - 14
&& [Min work center] = MAX( 'AssetManagement Open_N2'[Min work center] )
)
)
If i misunderstood what you want, please let me know.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous
Is it solved or still same issue! pleas share some sample data and the desired outcome snapshot so that i can help you!
Proud to be a Super User!
It isn't solved.
On the visual I am trying to get
Column_AgeEqORLt14Days = if ('AssetManagement Open_N2'[Created on]> TODAY()-14,1,0)
Column_AgeGT14Days = if ('AssetManagement Open_N2'[Created on]<= TODAY()-14,1,0)
Hi @Anonymous ,
Is that you want to calculate how many days are there depend on Min work center?
the results of two centers are same due to the function ALL(), it remove all the filter, so the result is the same. my solution is add more detail for the filter.
Try the following expression:
AgeGT14Days =
COUNTROWS(
FILTER(
ALL( 'AssetManagement Open_N2' ),
'AssetManagement Open_N2'[Created on]
< TODAY() - 14
&& [Min work center] = MAX( 'AssetManagement Open_N2'[Min work center] )
)
)
If i misunderstood what you want, please let me know.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
It works, thanks you.
Can you explain how the MAX works in this?
Hi @Anonymous ,
Its the same as SELECTEDVALUE( ). MAX() return the center name MN10 when the row's Min center is MN10, Min center is SN31, it will change to SN31.
SELECTEDVALUE function - DAX | Microsoft Docs
Best Regards
Community Support Team _ chenwu zhu
@Anonymous
create a DimDate Table instead of using the Date column Directly in the DAX
and then use below , hope it helps
AgeGT14Days = COUNTROWS(FILTER(ALL(DateDim),Datedim[Date] < today()-14))
Proud to be a Super User!
Thanks for your help,
Seems I am now getting the count of the DimDate Table instead.
AgeGT14Days = COUNTROWS(FILTER(ALL(DimDate),DimDate[DateKey]< today()-14))
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
108 | |
108 | |
92 | |
67 |
User | Count |
---|---|
161 | |
129 | |
129 | |
92 | |
91 |