topic Re: Count condition in place of Total column in DAX Commands and Tips

Count condition in place of Total column

gujralh — Sun, 02 Jun 2024 09:38:17 GMT

Hello All,

How I can replace Total column with countif condition (say >36000 for last 8 days) in below matrix visual.

I tried by creating other measure for same count if condition and added in visual but it is giving value against every date and that I don't want. I need just same matrix (1st) with Count if condition instead of total column.

Re: Count condition in place of Total column

Jihwan_Kim — Sun, 02 Jun 2024 13:11:47 GMT

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

I changed a condition to implement last three days sales amount, but I hope you can change the condition based on your business logic.

expected result sales: = VAR _lastdate = MAXX ( SUMMARIZE ( sales, 'calendar'[Date] ), 'calendar'[Date] ) VAR _lastthreedays = FILTER ( ALL ( 'calendar' ), 'calendar'[Date] <= _lastdate && 'calendar'[Date] >= _lastdate - 2 ) RETURN SWITCH ( TRUE (), ISINSCOPE ( 'calendar'[Date] ), SUM ( sales[sales] ), CALCULATE ( SUM ( sales[sales] ), _lastthreedays ) )

Re: Count condition in place of Total column

gujralh — Mon, 03 Jun 2024 23:42:04 GMT

Thanks Jihwan_Kim

Re: Count condition in place of Total column

gujralh — Thu, 06 Jun 2024 23:45:26 GMT

Jihwan_Kim
How we can filter out with item say >5 value on any specific date (say 5/31) which show those rows only with your shared calculation.

Actually when I'm filtering any greater than value than its only putting the blank value in columns. But I need it to show those items rows only when condition meets for selected date, rest all should be hidden.

Re: Count condition in place of Total column

Jihwan_Kim — Fri, 07 Jun 2024 02:52:07 GMT

Hi,

Sorry that it is a little bit difficult for me to understand your question.

Please provide your sample pbix file's link together with how your expected outcome looks like.

It will help for me to understand more clearly.

Thank you.

Re: Count condition in place of Total column

gujralh — Fri, 07 Jun 2024 13:28:21 GMT

Hi Jihwan_Kim

I need the data in this way, like when i filter value on date (say 6/4/2024) with greater than value 36000 then its showing those rows only , this i did in excel.

But in power BI, It only replace with blank rows only.[Say matrix 2 from PB]

Re: Count condition in place of Total column

Anonymous — Wed, 19 Jun 2024 02:10:50 GMT

Hi gujralh ,

I think one of the misconceptions you have is that in Power BI Desktop, whether you select Table view or Matrix view, as long as there is a value for the current row, then it is also not possible to hide certain rows like Excel will.

In other words, if you want to hide the row, it will only be visible in Visual if it does not have any value. The following screenshot is an example you can refer to.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.