Hello, In a visualization, I want showing in the y axis for each data series item count of total count of AgeGT14Days count of AgeEqORLt14Days I have 2 DAX expressions AgeGT14Days = COUNTROWS(FILTER(ALL('AssetManagement Open_N2'),'AssetManagement Open_N2'[Created on] = today()-14)) however for AgeGT14Days AgeEqORLt14Days 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?

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Count row per date

Thread starter GlennL
Start date Nov 8, 2021

GlennL

New Member

Nov 8, 2021

Hello,

In a visualization, I want showing in the y axis for each data series item

count of total
count of AgeGT14Days
count of AgeEqORLt14Days

I have 2 DAX expressions

Code:

AgeGT14Days = COUNTROWS(FILTER(ALL('AssetManagement Open_N2'),'AssetManagement Open_N2'[Created on] < today()-14))

Code:

AgeEqORLt14Days = COUNTROWS(FILTER(ALL('AssetManagement Open_N2'),'AssetManagement Open_N2'[Created on] >= today()-14))

however for

AgeGT14Days
AgeEqORLt14Days

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?