How to bring Don't summarize to measure?

[froxas]

What I have to do: I have to make a table with columns "Contract no", "version", "status" and "name" ("name" is from other table). "Status" is calculated dynamically, it is measure. one contract have many "names".

When i drop all columns to report except "status" i get a table what i need (first foto).

but when I add "status" to table ("status" is measure) then i get "name" repeated many times, wrong (second foto).

My idea is to bring "name" into table in measure, not just pull from menu. but i need with a condition "Don't sumarize". Is there way to make measure and do dont sumarize? because like that is not good for me: CALCULATE(MAX(name);.....)

[marcyhelen]

Ayuda por favor, requiero obtener el % en la columna parrila, desde una medida, actualmente la obtengo con "no resumir". 

[Icey]

Hi @froxas ,

First, as @amitchandak said, there is no summarize option for measures.

Then, In my experience, I think the cause is not whether the measure is summarized.

If you don't mind, please share me a dummy PBIX file, removing real data and sensitive information, for checking.

Best Regards,

Icey

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

[froxas]

Thanks guys for your efforts to help me solving this issue. below is the link to source files:
Link to files 

I made two table: table in the right what i should see, but when i add status to table in the left i get all these names repeated. Status is calculated measure.

I need the context to be: client name, contract number.

 

[Icey · Accepted solution]

Hi @froxas ,

According to my understanding, the issue is caused by the context of the table visual.

Create a measure like so:

Status 2 = 
VAR t =
    ADDCOLUMNS (
        FILTER ( CROSSJOIN ( contracs, deptors ), [id] = [contract_id] ),
        "Status", IF ( DATEDIFF ( [start_date], [end_date], DAY ) > 30, "ACTIVE", "PASSIVE" )
    )
RETURN
    MAXX ( t, [Status] )

For more details, please check the attached PBIX file.

Best Regards,

Icey

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

[pretzmendap]

Hi, i also faced the same issue

In my report, it will display two column from two different tables which Tenancy Agreement[Sqft] and Sales[Tenant Sales]. Both table is link with Sales[TenancyAgreementID] = Tenancy Agreement[TenancyAgreementID]. In the report, Tenamt Sales will be summarize while Sqft dont summarize. I need to create one measure to which will divide Sales with Sqft. In the image below i try to do it as SalesPerSquareFoot but the result doesn't correct. The formula should be Sales[Tenant Sales]/Tenancy Agreement[Sqft]

The formula for SalesPerSquareFoot measure is ;

Can advise on this issue?

[froxas]

@Icey  thank! that's working fine. this is what i wanted.

[amitchandak]

@froxas 

Measure does not have do not summarize option. Keep some ID column in the table that will keep the correct row context

[Greg_Deckler]

Sample data and measure formula would be greatly helpful. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490