No. of events in a column based on measure

[muhammadh811]

Hello
I have created a measure that shows me if the Venture is "Risky" or "Partial" against each venture. Now I want to count how many trades are "Risky" and how many are "Partial"

Thanks

[VijayP]

@muhammadh811 

https://drive.google.com/file/d/1ty4lgspcNz9loK5ISi-IRfoKdptfMNcW/view?usp=sharing

Find the file

Hope this is what you are looking for if so please mark this as solution and share your Kudoes

Vijay  Perepa

[muhammadh811]

Just to clarify, I have [Status] as a measure not a column in data. 
First I have created a measure which tells me whether a Venture is "Risky" or "Partial". Now I want to see how many Ventures are "Risky".

[Fowmy]

@muhammadh811 

Did you try the solution that I shared, It uses your measure.

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[VijayP]

@muhammadh811 

Yes if you ignore the column part remaining to measures will tell what exactly you wanted to see.

[Fowmy]

@muhammadh811 

You can create two measures as 

Risky Count = 

CALCULATE(
    COUNTROWS('Table'),
    FILTER(
        Table,
        [Status] = "Risky")
)

---------------------------------------------
Partial Count = 

CALCULATE(
    COUNTROWS('Table'),
    FILTER(
        Table,
        [Status] = "Partial")
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[muhammadh811]

@Fowmy brother, I am unable to get results that I am looking for.

[amitchandak]

@muhammadh811 , Assume you have create some calculation , where you have like

Switch(True(),

<Condition>, "Risky",

/// and so on,

)

Same way create a measure that returns 1 for risky and 0 or Blank() when it not risky

Sumx(Values(Table[Venture]),

Switch(True(),

<Condition Risky is true>, 1, blank()

))

You can use IF in place of Switch.

[muhammadh811]

I tried your solution but it's not giving the correct number.

[Fowmy]

@muhammadh811 

The measure I shared is not that, please check it again in my reply. I am getting 11 Risky

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[VijayP]

@muhammadh811 

Use The measures with Calculate(.....)in my pbix you will get the answer

[muhammadh811]

@VijayP 
I can't use [Status] = "Risky" in calculate as "Status" is a measure and BI is throwing an error message.

[VijayP]

@muhammadh811 

Can you share the measure you have created to get the Risky,Partial. Based on that i can make soltuion out

[muhammadh811]

@VijayP 

Status =

VAR _Value = MIN('Position Manager - Exported_Gra'[Venture])

RETURN

IF(CALCULATE(DISTINCTCOUNT('Position Manager - Exported_Gra'[B/S]), 'Position Manager - Exported_Gra'[Venture] =_Value)>1,"Partial","Risky")

[v-kelly-msft · Accepted solution]

Hi  @muhammadh811 ,

Create 2 measures as below:

_Risky count = CALCULATE(COUNTROWS('Position Manager - Exported_Gra'),FILTER(ALL('Position Manager - Exported_Gra'),'Position Manager - Exported_Gra'[Status]="Risky"))

_Partial count = CALCULATE(COUNTROWS('Position Manager - Exported_Gra'),FILTER(ALL('Position Manager - Exported_Gra'),'Position Manager - Exported_Gra'[Status]="Partial"))

And you will see:

Here,status is a measure per your description.

For details,you may refer to attachment.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!