Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Count Rows with a Sum Condition

Hi Experts

 

My current measure gives me the correct count of row

Total= CALCULATE(COUNT('STG Fact_'[Actual_end_date])
 
i want to apply the £ value to that count
my mesure that gives me the £ value is 
[Annual Value (£)]
 
 
 
1 ACCEPTED SOLUTION

@Anonymous 

Can you try this measure, need more explanation though.

Measure  = 
 
VAR __M =  CALCULATE(COUNT('STG Fact_'[Actual_end_date]) ) RETURN

IF( _M = 5 , [Annual Value (£)] , BLANK() )

 

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

@route217

Total= CALCULATE(COUNT('STG Fact_'[Actual_end_date]))*130.76 &" " &UNICHAR(163)

Anonymous
Not applicable

Apologies I have not explained the question probably.. if the count measure gives 5, then the £ measure with count must give 16. Not the £ sign added to the count

 

DateValue £
01/09/20203
02/09/20204
03/09/20202
04/09/20203
05/09/20204
516

 

@Anonymous 

Can you try this measure, need more explanation though.

Measure  = 
 
VAR __M =  CALCULATE(COUNT('STG Fact_'[Actual_end_date]) ) RETURN

IF( _M = 5 , [Annual Value (£)] , BLANK() )

 

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Anonymous
Not applicable

160085989683613051553710809116.jpg

Anonymous
Not applicable

Hi Fowmy

 

from my model,I can count the Agreement_ closed (Table B) which links to my fact table A - table C is the values Table. All tables are connect via Merchant_ID (primiary key) no direct relationship between Table B and C.

 

I can count the closed Agreement in Table B using 

CALCULATE(COUNT('STG Fact'[Actual_end_date]) ) and the value is correct
 
to each of those closed agreement i want to add the £ cost - i how much in money was lost as a result of closing that agreement.

 

 

 

 

Anonymous
Not applicable

Then multiply with the rate you have. I have edited the DAX you can use that or refer it to write the DAX.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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