Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Experts
My current measure gives me the correct count of row
Solved! Go to 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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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
Date | Value £ |
01/09/2020 | 3 |
02/09/2020 | 4 |
03/09/2020 | 2 |
04/09/2020 | 3 |
05/09/2020 | 4 |
5 | 16 |
@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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |