Need help to show the AM and PM count of invoices submitted in matrix visual

[Bhanu_chPBI]

HI Team,

Can any one help me to show the invoice count as shown below image in matrix visual in power bi report.

[Anonymous]

Hi  @Bhanu_chPBI ,

Sorry, only now reply to you.

I'm not quite sure if you're saying "not showing AM and PM uploaded details" because I see in your matrix below that the AM and PM data is already displayed properly, or if you want to form three columns of AM, PM, AM&PM data.

You can express the results you want in the form of pictures, and we can help you better.

Best Regards,

Liu Yang

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

[Anonymous]

Hi  @Bhanu_chPBI ,

I created some data:

Here are the steps you can follow：

1. Create calculated column.

Date1 =
DATE(
    YEAR('Table'[Date]),MONTH('Table'[Date]),DAY('Table'[Date]))

Value_Column =
var _PM=
SUMX(FILTER('Table','Table'[Flag]="PM"&&'Table'[Date1]=EARLIER('Table'[Date1])&&'Table'[Group]=EARLIER('Table'[Group])),[Value])
var _AM=
SUMX(FILTER('Table','Table'[Flag]="AM"&&'Table'[Date1]=EARLIER('Table'[Date1])&&'Table'[Group]=EARLIER('Table'[Group])),[Value])
return
_AM&"/"&_PM

AMPM =
"AM"&"/"&"PM"

2. Matrix field placement.

3. Check the yellow tab.

4. Result:

Best Regards,

Liu Yang

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

[Bhanu_chPBI]

Hi @Anonymous ,

I need some more details regarding this issue i,e actually report need is changed and i used to do based on your solution but i need some requirement. actually invoice count iam getting based on grouping the client, date, AM-PM, INV process as Group column you mention. i have created seperate column as AM and PM with you dax measure coumn with grouped column as values as count. But while iam adding in matrix visual it is taking total row count based it is not showing AM and PM uploaded details. if need i have attached screen shots below. please check and let me gave some more details please.

[Bhanu_chPBI]

Hi @Anonymous,

can you please let me know my request please.

[Bhanu_chPBI]

Hello @Anonymous ,

Can you please let me know my request please.

[Bhanu_chPBI]

Hello @Anonymous,

Thank's a lot for your valuble support for my request. Thank you.

[Bhanu_chPBI]

i want show in above matrix visual as below table format. 

[amitchandak]

@Bhanu_chPBI , Is AM/PM is because of time?

You need to append two measure and create a text measure

AM/PM = calculate(Sum(Table[Value), filter(Table, timevalue(Table[DateTime]) <time(12,0,0) ) ) &"/" &calculate(Sum(Table[Value), filter(Table, timevalue(Table[DateTime]) >=time(12,0,0) ) ) 

[Bhanu_chPBI]

Hi @amitchandak ,

can you please let me know is it possible to show what i have mention in above requirement. i can't get you. I need to show both AM uploaded count and PM uploaded count in single column in matrix visual.

[Bhanu_chPBI]

Hi @amitchandak ,

I have attached the matrix visual need to looks like what i need in the report below.

[Bhanu_chPBI]

Hello Team,

Any Update Regarding my Help request!!