cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User IV
Super User IV

Re: AND IF in conditional column

Hi there

No worries glad to help out

My mate @MattAllington  has a great course here: https://exceleratorbi.com.au/courses-overview/





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

Proud to be a Super User!







Power BI Blog

Highlighted
Anonymous
Not applicable

Re: AND IF in conditional column

@GilbertQ 

@Michiel 

 

My Measure is giving correct result acorss column ie column subtotal is correct but row subtotal is wrong.

 

Can you suggest what could be wrong.Capture1.JPGCapture2.JPG

Highlighted
Resolver III
Resolver III

Re: AND IF in conditional column

'Wrong totals' is usually an effect of misunderstanding what the total row contains: it is not the total of the rows above, it's the result of the same measure in a different context, in this case without the row identifiers filtered.
So your measure is not a simple SUM, but you do want the total to add up. The solution in this case is to force DAX to calculate results on a row-by-row basis, you can do this with SUMX. Trying to mimic your model:

SUMX(VALUES(ProjectTable[Complete Project Detail]), [Your original measure])

or, if Complete Project Detail is unique in the Project table:

SUMX(Project, [Your original measure])

 

If you don' want to call another measure [Your original measure] but want to include the logic in this measure directly, it's probably safest to wrap it in CALCULATE:

SUMX(
    VALUES(ProjectTable[Complete Project Detail]),
    CALCULATE(<Your original formula goes here>)
)

Highlighted
Anonymous
Not applicable

Re: AND IF in conditional column

Capture.JPG

My measure is having the above calculation. The main measure is " Pay Distribution Project" . Can you please suggest now ,where I am going wrong.

 

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Power BI Desktop August 2020 Update

Power BI Desktop August 2020 Update

We have great updates this month! Click the link for the video with more info.

Top Solution Authors
Top Kudoed Authors