DAX

Hi Sujit_Thakur ,

What you can try is created a calculated column which defines your categories as <0.25 , 0.25-0.50 , 0.50-0.75, >0.75 based on your TEST measure.

Then try using this column in a matrix visual under COLUMN section along with your Name column under ROW section.

Thanks,

Pragati

Sujit_Thakur , see if segmentation can help

SEGMENTATION

https://www.daxpatterns.com/dynamic-segmentation/
https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-power-query/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization

Hi Sujit_Thakur ,

We create a sample. We can use a matrix table and a measure to meet your requirement.

1. Create a new table.

Table 2 = CROSSJOIN(VALUES('Table'[Name]),{"<0.25","0.25-0.5"})

2. Then we can create a matrix table based on the new table, create a measure and put it in Values.

Measure 2 = 
SWITCH(
    TRUE(),
    MAX('Table 2'[Value]) = "<0.25",CALCULATE(COUNT('Table'[Name]),FILTER('Table',[Measure]<0.25 && 'Table'[Name]=MAX('Table 2'[Name]))),
    MAX('Table 2'[Value]) = "0.25-0.5",CALCULATE(COUNT('Table'[Name]),FILTER('Table',[Measure]>=0.25&&[Measure]<0.5 && 'Table'[Name]=MAX('Table 2'[Name]))))

If it doesn’t meet your requirement, could you please provide a mockup sample based on fake data or describe the fields of each tables and the relations between tables simply?

It will be helpful if you can show us the exact expected result based on the tables.

Please upload your files to OneDrive For Business and share the link here. Please don't contain any Confidential Information or Real data in your reply.

Best regards,

Community Support Team _ zhenbw

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

BTW, pbix as attached.

Hi Sujit_Thakur 

Add this table to your model. I have named this HP-OP-Bounds.

After that create two calculated columns(HP/OP and Bin) as shown below in your table. I have named this table 'HP-OP'.

The formulaes for calculated columns are shown below.

HP/OP = DIVIDE('HP-OP'[HP], 'HP-OP'[OP], 0)


Bin = 
VAR X = 'HP-OP'[HP/OP]
VAR Filtered =
    FILTER (
        'HP-OP-Bounds',
        VAR Y = 'HP-OP-Bounds'[Upper Bound] RETURN 'HP-OP-Bounds'[Lower Bound] <= X
            && IF ( ISBLANK ( y ), TRUE (), Y > X )
    )
RETURN
    MAXX ( Filtered, 'HP-OP-Bounds'[Bin] )

Now use matrix visual as shown below.

Hope this helps.

Appreciate with kudos.

Please mark it as solution if this resolves your problem.

Thanks

---

Sujit_Thakur wrote:

Which returns a table so I was thinking if is it possible to get my expected result using evaluate

---

No, EVALUATE is not avaialbe within PBI, at least not in this sense. The only place it could be used is to import data from SSAS, for example.

Dear Greg_Deckler 

Please spread  some light on above question 🙏

Sujit_Thakur  If the segments are fixed i.e. (<0.25        0.25-0.50      0.50-0.75     >0.75). 

You can use the parameter table pattern.

Dear v-zhenbw-msft  Greg_Deckler  and all ,

following is pasted  data sample for question , please note the measure" Test" is nothing but divide(HP,OP).

I hope after this sample data v-zhenbw-msft  you can help me with your previously discussed technique

Sujit_Thakur How do you intend too use date slicer?

I guess the HP/OP formulae become SUM(HP)/SUM(OP) for a selected date range right?

Dear  v-zhenbw-msft  ,

following is my data 

 1)First table is index table

2)Second is data table 

Now what i want as an output is 

Model    Total  Count    <0.25   0.25-0.50  0.50-0.75   >0.75 

Alpha                 2              2                            
Bravo                 2              1                                             1
Charlie               1             1

please  also explain your code of switch function  i didnt understood