Need help in DAX formula

[prasadavasare]

Need to add a column in above pivot which shows [Dezired result] the count of [Credit Family Names] whose [Sum of Sum of Primary used USD] is equal to Zero or Blank: Note: I am using Excel 2013 power pivot. No Power Query.

<st1:stockticker>SCG</st1:stockticker>	N
PCD	(All)
<st1:stockticker>CPC</st1:stockticker>	(All)
CLT	(All)
Bucket	(Multiple Items)
<st1:stockticker>COB</st1:stockticker>	8/31/2017

<colgroup><col><col></colgroup><tbody>
</tbody>

PCE	Credit Family Name	Sum of Sum of Primary Used USD	Count of Credit Family Name	Desired Result
Fostxxxxxxxxx	Rudixxxxxxxxxxx	0	1	1
Fostxxxxxxxxx Total		0	1	1
Gonzxxxxxxxxx	Autixxxxxxxxxxxxxxx	6,922,542	1
	TURNxxxxxxxxxxxxxxxx	36,845,505	5
Gonzxxxxxxxxx Total		43,768,047	6
Indrxxxxxxxxx	WATCxxxxxxxxxxxxxxxx	2,000,000	1
Indrxxxxxxxxx Total		2,000,000	1
Keglxxxxxxxxx	PROMxxxxxxxxxxxxxxxx		1	1
	ROMOxxxxxxxxxxxxxxxx	3,577,278	4
	DEL xxxxxxxxxxxxxxxx	3,646,318	1
	LUCExxxxxxxxxxxxxxxx	5,938,030	1
	INVExxxxxxxxxxxxxxxx	25,000,000	3
	PABExxxxxxxxxxxxxxxx	38,294,371	6
Keglxxxxxxxxx Total		76,455,997	16	1
Martxxxxxxxxx	VINSxxxxxxxxxxxxxxxx	0	1	1
	PORTxxxxxxxxxxxxxxxx	0	1	1
	STANxxxxxxxxxxxxxxxx	250,000	1
	STANxxxxxxxxxxxxxxxx	3,090,534	1
	ALLExxxxxxxxxxxxxxxx	11,082,173	1
	HORIxxxxxxxxxxxxxxxx	68,500,000	3
Martxxxxxxxxx Total		82,922,707	8	2
McNaxxxxxxxxx	ABKCxxxxxxxxxxxxxxxx	0	1	1
McNaxxxxxxxxx Total		0	1	1
Mendxxxxxxxxx	BRC xxxxxxxxxxxxxxxx	102,075,000	6
Mendxxxxxxxxx Total		102,075,000	6
Portxxxxxxxxx	RICHxxxxxxxxxxxxxxxx	0	2	1
	PALLxxxxxxxxxxxxxxxx	21,537,779	1
Portxxxxxxxxx Total		21,537,779	3	1
Powoxxxxxxxxx	AMERxxxxxxxxxxxxxxxx		8	1
	CENTxxxxxxxxxxxxxxxx		2	1
	STANxxxxxxxxxxxxxxxx	0	1	1
Powoxxxxxxxxx Total		0	11	3
Siegxxxxxxxxx	STANxxxxxxxxxxxxxxxx	352,236	1
Siegxxxxxxxxx Total		352,236	1
Swicxxxxxxxxx	ALL xxxxxxxxxxxxxxxx	1,083,463	2
Swicxxxxxxxxx Total		1,083,463	2
Grand Total		330,195,229	56	9

<tbody>
</tbody>

 

[prasadavasare]

Need help urgently for dashboard

 

[prasadavasare]

Need help urgently for dashboard

I tried using below in power pivot dax function but unsuccessful:

Support1:=IF(SUM(Annual_Data_History[Sum of Primary Used USD])=0,CALCULATE(DISTINCTCOUNT(Annual_Data_History[PCE])),BLANK())

 

[akice]

you can try this:

measure := SUMX (
    VALUES ( Table[Credit Family Name] ),
    IF ( [Sum of Sum of Primary Used USD], 0, 1 )
)

But a bit of a shot in the dark.

 

[prasadavasare]

That works. Thank you so much.

One more help needed. Need to create Rag Rating Column at:
1 Credit Family Name level
2 PCE Level

1. Credit Family Name Level
if Max DPD >90 then R
if Max DPD >30 then A else G

2. PCE Level
if Max of Max DPD >90 then R
if Max of Max DPD >30 the A else G