Reply
Edgar_massa
Helper II
Helper II
Partially syndicated - Outbound

okay icon

I have the following table.

Edgar_massa_0-1719613269843.png

And I have the following matrix look

 

Edgar_massa_1-1719613364368.png

 

The "Planned" measure is:

    CALCULATE(
        SUM( fac_NFs_SFs[valor_liquido_nf] ),
        USERELATIONSHIP( dim_Calendario[Data], fac_NFs_SFs[data_previsao_recebimento] )
)
 
The "Achieved" measure is:
    CALCULATE(
        SUM( fac_NFs_SFs[valor_liquido_nf] ),
        USERELATIONSHIP( dim_Calendario[Data], fac_NFs_SFs[data_recebimento] )
)

 

The months "Mar", "Mai" and "Jun" = dim_calendario[mês]

 

I need that when I have a receipt date, all the month contexts have the Okay icon, ignoring the month of the column context.

I can't do this because the forecast sum uses the forecast column and the received sum uses the received date column.

What do I do?

3 REPLIES 3
lbendlin
Super User
Super User

Syndicated - Outbound

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Syndicated - Outbound

What is the expected result?

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)