Count Values from Table Visualization

[franciscogsp]

Hi, I'm trying to find a solution to a count I need to do, but I'm not succeeding.

I have a Table Visualization in my Model, where it has some columns with fields that come from diferent Power Query tables, and other columns that are measures.



Delta [k€] and Delta [%] are measures, and in this table, a filter is applied to only show projects above 20% and below -20%.

What I wanted to do was a card that would count how many projects are above 20%, which in this situation will be 5 projects and I'm not getting there.

Thanks in advance.

[Jayee · Accepted solution]

Hi @franciscogsp 

Try the below measure

No of projects = Sumx( summarize( Tablename,[contract name], "Projects", If( [Delta]>0.2,1,0)),[Projects])

I am assuming the delta is giving values between 0 to 1 so i added condition is 0.2 which is 20%.

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!

[Jayee]

May be you can provide sample data without sensitive information so that I can able to support you further.

[franciscogsp]

Hi Jayee,

I have replicated this part of the Model for you to understand how it is structured and what Measures are being done.

Here is the download link

Many Thanks

[Jayee · Accepted solution]

@franciscogsp 

I am getting the count same as table here the measures i have used

No of Projects < -20% = SUMX(SUMMARIZE('Contract Info','Contract Info'[Project Name],"X",IF([Delta %]<-0.2,1)),[X])

No of Projects > 20% = SUMX(SUMMARIZE('Contract Info','Contract Info'[Project Name],"X",IF([Delta %]>0.2,1)),[X])

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!

[franciscogsp]

Ah, In the SAP table, there are more columns, which divide the costs by categories, Ledger Codes, but I did not find it relevant to add in this example. 

[Jayee · Accepted solution]

Hi @franciscogsp 

Try the below measure

No of projects = Sumx( summarize( Tablename,[contract name], "Projects", If( [Delta]>0.2,1,0)),[Projects])

I am assuming the delta is giving values between 0 to 1 so i added condition is 0.2 which is 20%.

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!

[franciscogsp]

I'm new to Power BI and didn't know that when I put in a view card, to get the sum equal to the table I had, I had to put in exactly the same filters.

After replicating the filters in the filters zone, in the visualization card, with this formula everything worked.

thank you very much

[franciscogsp]

Hi, after trying your formule, I tried putting the measure on a display Card and this was the result:

And yes, you are taking on Delta's value well