<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Arunagiriharika on Medium]]></title>
        <description><![CDATA[Stories by Arunagiriharika on Medium]]></description>
        <link>https://medium.com/@arunagiriharika?source=rss-7833d0688837------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*rLH0jodbtTxfMXDP</url>
            <title>Stories by Arunagiriharika on Medium</title>
            <link>https://medium.com/@arunagiriharika?source=rss-7833d0688837------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sat, 21 Nov 2026 22:18:06 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@arunagiriharika/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[About Count, CountX, CountA, CountAX, and difference using DAX in Power BI]]></title>
            <link>https://medium.com/@arunagiriharika/about-count-countx-counta-countax-and-difference-using-dax-in-power-bi-e5b661177053?source=rss-7833d0688837------2</link>
            <guid isPermaLink="false">https://medium.com/p/e5b661177053</guid>
            <dc:creator><![CDATA[Arunagiriharika]]></dc:creator>
            <pubDate>Fri, 17 Sep 2021 17:52:41 GMT</pubDate>
            <atom:updated>2021-09-17T17:52:41.172Z</atom:updated>
            <content:encoded><![CDATA[<p>If we want to count the number of values in a column.</p><p>Let us see the difference in Count, CountX, CountA, CountAx</p><p><strong>Example</strong>:</p><p>Taking a simple example in tabular format</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/407/1*fx8W77DlMKtFPn1vIo6EMg.png" /></figure><p><strong>Count:</strong></p><p><strong>Count</strong> function counts the number of cells in a column that contains numbers, Dates, strings.</p><p>The <strong>Count </strong>function does not count empty (or) blank values.</p><p>The <strong>Count</strong> function does not count boolean functions but <br>If you include true/false with categorical data and numerical values it will count. The only boolean values does not count.</p><p>The C<strong>ount </strong>function contains blank data it returns blank.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/744/1*W-pZ7FqrP0UXyMdQpu4Bag.png" /></figure><p>In the above picture, you can see I include true/false in the name it will count. In phone numbers blank it returns blank. In fees I had given true it is counted</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/767/1*2BLRZZJMUAk5z96tNxz9zg.png" /></figure><p>In the above picture, you can see if you take boolean values it shows an error. The function c<strong>ount </strong>cannot work boolean values.</p><p><strong>Syntax</strong>: COUNT(&lt;column&gt;)</p><p><strong>Example </strong>: count_id = COUNT(data[id])</p><p>I had taken function to count id column.you can see it is 7 so the output is 7.</p><p><strong>Output</strong>: 7.</p><p><strong>CountX:</strong></p><p><strong>CountX</strong> function counts the number of cells in a column that contains numbers, Dates, strings.</p><p>The <strong>CountX </strong>function does not count empty (or) blank values.</p><p>The <strong>CountX</strong> function does not count boolean values but <br>If you include true/false with categorical data and numerical values it will count. The only boolean values does not count.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/749/1*tr56rt9F38F_Or6Mlv1tsQ.png" /></figure><p><strong>Syntax : </strong>CountX (&lt;table_name&gt;,&lt;expression&gt;)</p><p><strong>Example </strong>: countx_name = COUNTX(data,data[name]).</p><p>I had taken the name as count so we can see 7 columns output is 7</p><p><strong>Output</strong>: 7</p><p>The <strong>CountX</strong> function we can also do filters.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/760/1*6GFaN1jlZlhBSXAjFhJOfA.png" /></figure><p>In the above picture, you can see filtered on Power BI you can see count of Power BI.</p><p><strong>Syntax </strong>: CountX(Filter(table_name,expression)</p><p><strong>Example </strong>: COUNTX( FILTER(data,data[course]=”power bi”),data[Course])</p><p>I want filter how many Power BI numbers are there you can see it is 2 so output is 2</p><p><strong>Output </strong>: 2.</p><p><strong>CountA:</strong></p><p>The <strong>CountA </strong>function counts the number of cells in a column.</p><p>The <strong>CountA</strong> function does not count empty (or) blank values.</p><p>The C<strong>ounta</strong> function counts boolean functions.</p><p>The <strong>CountA</strong> function counts numbers, strings, dates, boolean.<br>The <strong>CountA</strong> function contains blank data it returns a blank.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/753/1*8GkjpK5Y7dAdHE1BSOraXQ.png" /></figure><p>In the above picture, you can see boolean values are counted.</p><p><strong>Syntax </strong>: COUNTA(&lt;column&gt;).</p><p><strong>Example </strong>: counta_phone number = COUNTA(data[Phone Number])</p><p><strong>Output </strong>:Blank.(Phone number is blank it returns blank).</p><p><strong>CountAX :</strong></p><p>The <strong>CountAX</strong> function counts the number of cells in a column.</p><p>The <strong>CountAX </strong>function does not count empty (or) blank values.</p><p>The <strong>CountAX </strong>function counts boolean values.</p><p>the <strong>CountAX </strong>function counts numbers, strings,dates,boolean values.<br>the <strong>CountAX </strong>function contain blank data it return blank.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/741/1*ZocsMttfXEtrSQ7NRhWOow.png" /></figure><p><strong>Syntax </strong>: COUNTAX(&lt;table_name&gt;,&lt;expression&gt;)</p><p><strong>Example </strong>: Countax_logical = COUNTAX(data,data[Logical])</p><p><strong>Output</strong>:7.</p><p>In logical values, you can 7 logical values so the output is 7</p><p>In <strong>CountAX</strong> you can do filters.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/741/1*1Rs7Au9LOkiIpLOwu3dLcw.png" /></figure><p>In the above picture, you can be filtered how many 10000 are there you can see a count of 10000.</p><p><strong>Syntax </strong>: CountaX(Filter(table_name,expression)</p><p><strong>Example</strong>: countax_filter = COUNTAX( FILTER(data,data[fees]=”10000&quot;),data[Fees])</p><p><strong>Output </strong>: 3</p><p><strong>Difference between Count, CountX, CountA, CountAX.</strong></p><p>Taking a simple example in tabular format.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/608/1*YFfljaubSw68K0ONR48YAg.png" /></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=e5b661177053" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[About Line Chart In Power BI]]></title>
            <link>https://medium.com/@arunagiriharika/about-line-chart-in-power-bi-edd2d497becf?source=rss-7833d0688837------2</link>
            <guid isPermaLink="false">https://medium.com/p/edd2d497becf</guid>
            <dc:creator><![CDATA[Arunagiriharika]]></dc:creator>
            <pubDate>Thu, 09 Sep 2021 11:36:26 GMT</pubDate>
            <atom:updated>2021-09-09T11:36:26.241Z</atom:updated>
            <content:encoded><![CDATA[<ul><li>This article shows when to use a <strong>Line chart</strong> and how to use.</li><li>To improve <strong>Business</strong> we need to know where sales got dropped and sales got raised, in the previous year, previous month, day, to compare sales and profit.</li><li>If we want to compare <strong>Numerical Data</strong> along with the <strong>Date</strong> and <strong>Additional Axis</strong> we will go to a <strong>Line Chart</strong>.</li><li>Here am taken data which is regarding <strong>Sales</strong> information.</li><li>Let’s see a simple example<br> (please note the data set used here is from the superstore)<br> consider the below ABC store dataset</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*VH1ZfWKTzoO1p1_QJ8z8sg.png" /></figure><p>The data provides information about order date, ship date, region, customer name, country, sales, profit, category, subcategory and so on.</p><p>Select a <strong>Line Chart </strong>from <strong>visualization </strong>panel.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/178/1*OmzFKo_5hodgorr6Hl-NUg.png" /></figure><p>In Desktop creates an empty <strong>Skeleton </strong>visual design.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/364/1*y08nzOZ1hfHFYkHS_cQ8TQ.png" /></figure><p>Follow steps to create a <strong>Line Chart:</strong></p><p>In the fields panel we will see Axis, Values, and Secondary values.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/168/1*9Wx9dxId0twHBtuiLCs8Cg.png" /></figure><ul><li>Drag Order Date to the <strong>Axis</strong></li><li>Drag Sales to <strong>Values </strong>and</li><li>Drag profit to <strong>Secondary Values</strong></li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/174/1*_0j4Dzh-gPwHZbdLEgwZxA.png" /></figure><p>After Dragging the order date to the axis we will see. <strong>Hierarchy </strong>like a year, quarter, month, day we can set in year wise month wise like that.</p><p>Let’s see month wise.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/169/1*qk2Y9GapM7HLQS6OX-w-mg.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/181/1*v7VtQ_EIwVvTo1NShw3tCA.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/712/1*lNEppTB4sumymZx1ecQ05A.png" /></figure><ul><li>The Blue line indicates <strong>Sales</strong> Violet Line indicates P<strong>rofit</strong>.</li><li>We can see in above in the month of January to December how much sales was done and how much profit was done.</li><li>Pointing and connected by line segments.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/697/1*ix2PinftgbaFDMGHV_ukXw.png" /></figure><p>During the month of January the sales is 94,924.84 and profit is 9,134.45.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/718/1*IzmSuYWaQmguLAR7_Ynf7Q.png" /></figure><p>We can see the month of October sales reduced and profit was raised so we can assume in the month of October there is no discounts so sales get reduced.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/732/1*rRBCF6pbYkW2TXzyF_kKog.png" /></figure><p>We can see in the month of November sales is raised and profit was reduced so we can assume in the month of November there is no discounts so profit get raised.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/190/1*4GqCstcJhnYOD6hcc6g7mg.png" /></figure><p>When you select Format, The icon displays customization is available for the currently selected visualization.</p><p>The options available are :</p><ul><li>General</li><li>legend</li><li>X axis</li><li>Y axis</li><li>secondary value</li><li>Zoom slider</li><li>Data colors</li><li>Data labels</li><li>Shapes</li><li>Plot area</li><li>Title</li><li>Back ground</li><li>Lock aspect</li><li>Border</li><li>Shadow</li><li>Tool tip</li><li>Visual header</li></ul><p>In the format we can edit like font, color, font family, data labels and we can change line color in data color.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/596/1*LF8AKwHAeA_LUInoUtl0KQ.png" /></figure><p>If you on data labels we can see like this by knowing how sales and profit done.</p><p>In format shapes we can give line stroke width, we can give line as solid, dashed, dotted.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/159/1*tYNhIpRWSJKYId1WYLHh7g.png" /></figure><p>In format shapes show maker we can see this options.</p><p>We can change connecting points by Circles, Square, and so on we can change color and size as well.</p><figure><img alt="By adding square we can see in above picture" src="https://cdn-images-1.medium.com/max/606/1*nOpIOQcnVK1dkP9hsC2Idw.png" /><figcaption><strong>By adding Square</strong></figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/609/1*iR0XUgq3Oc5qk6RwgyZZUw.png" /></figure><p>If you on step on shapes we can see like steps</p><p>We can also give title, title color, font, font family, shadow, border</p><p>We can change background color and you can add background picture.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/686/1*Rd8HvOY9Xhzu5Vxt-xsqSA.png" /></figure><p>In the above picture, you can see Sales and Profit by <strong>month</strong>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/643/1*hzik-V1xO7Rs7APTfod3wQ.png" /></figure><p>In the above picture, you can see Sales and Profit by <strong>Year.</strong></p><p><strong>Conclusion</strong>:</p><ul><li>If you want <strong>Date </strong>information along with <strong>Numerical </strong>information always l<strong>ine chart</strong> is Best one and advantage is we can add <strong>secondary values</strong>.</li><li><strong>Main propose is to show comparison of Sales and Profit</strong>.</li></ul><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=edd2d497becf" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>